Welcome to the LimeSurvey Community Forum

Ask the community, share ideas, and connect with other LimeSurvey users!

Sum a Multiple Numerical Input

dweisser
Topic Author
Offline
Premium Member

More

10 years 8 months ago #104853 by dweisser

Sum a Multiple Numerical Input was created by dweisser

Hi Team,
I need to sum a multiple numerical input question, and use the sum value in piped text via Expression Manager.
Is there a way to do this? Javascript?

Thank you all,
David

The topic has been locked.

DenisChenu
Offline
LimeSurvey Community Team & Official Partner

More

10 years 8 months ago #104889 by DenisChenu

Replied by DenisChenu on topic Sum a Multiple Numerical Input

Hi,

{sum(that.QCODE)} or {sum(self)} inside question

See www.limesurvey.org/manual/Expression_Man....27that.27_variables

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member. - Professional support - Plugins, theme and development .
I don't answer to private message.

The following user(s) said Thank You: socius

The topic has been locked.

dweisser
Topic Author
Offline
Premium Member

More

10 years 8 months ago #104916 by dweisser

Replied by dweisser on topic Sum a Multiple Numerical Input

As always, thank you Denis!

The topic has been locked.

taltos
Offline
New Member

More

6 years 10 months ago #161422 by taltos

Replied by taltos on topic Sum a Multiple Numerical Input

Hi !,

here is a way to have the sum under the multiple numerical input question ? (not in the body of the question)

number of women:
number of men:
Total:

thx for your help !

The topic has been locked.

Joffm
Offline
LimeSurvey Community Team

More

6 years 10 months ago #161436 by Joffm

Replied by Joffm on topic Sum a Multiple Numerical Input

Hi, taltos,

It is done out of the box if you use a question of type "array(texts)"

Following "Advanced settings"

And result:

Best regards
Joffm

Volunteers are not paid.
Not because they are worthless, but because they are priceless

Attachments:

The following user(s) said Thank You: socius

The topic has been locked.

socius
Offline
Premium Member

More

6 years 8 months ago #164003 by socius

Replied by socius on topic Sum a Multiple Numerical Input

Hi Joffm,

thanks for your hint to the built in column, row and total sums! makes asking and answering questions on budgets really easy. a hidden gem to me - but maybe I should just read the docs ;-)

My only problem here was, that the labels for the Totals ("Total" etc.) are not translated in LS 2.6.4 LTS, whereas in the above example where you use a more recent version of LS they already are.

I'd like to translate these (s. www.limesurvey.org/manual/Translating_LimeSurvey , translate.limesurvey.org/projects/limesu.../de/default/?filters [term]=total) but for the moment I just wanted to quick (and dirty) replace the "Total" by "Gesamt" and just scripted this:

Code:

<script type="text/javascript" charset="utf-8">
 
$(document).ready(function() {
    replacetotaltext();
});
 
function replacetotaltext() {
    var x = document.getElementsByClassName("answertext total");
    x[0].innerHTML = "Gesamt";
};
 
</script>

This works, but: I'm not a programmer - so my (probably naive) question is: is there an easier way to solve this without scripting (e.g. edit the .mo?), and: are there any possible negative side effects here with the script above? (e.g. naming of function, variables, etc.).

Best,
G

Attachments:

...Test180209.png

The topic has been locked.

jelo
Offline
Platinum Member

More

6 years 8 months ago #164007 by jelo

Replied by jelo on topic Sum a Multiple Numerical Input

Total is a valid German word too ;-)

So I wouldn't call it a missing translation. But Gesamt is more common.

You can modify the language files. But I wouldn't call it easier, since if a update comes along, the files might get overwritten. The workaround looks OK to me.

Not sure if the newest LTS is using Total or Gesamt.

The meaning of the word "stable" for users
www.limesurvey.org/forum/development/117...ord-stable-for-users

The following user(s) said Thank You: socius

The topic has been locked.

socius
Offline
Premium Member

More

6 years 8 months ago #164036 by socius

Replied by socius on topic Sum a Multiple Numerical Input

Hi jelo,

thanks for your response! I use the latest LTS and it says "Total" - which is also German indeed, but I'd prefer "Gesamt" or "Summe" in this case :-)

Thanks also for looking at the short script - I guess if I do not accidentally use an existing function name no too bad things should happen here ;-)

Thanks! Best, G

The topic has been locked.

jelo
Offline
Platinum Member

More

6 years 8 months ago #164054 by jelo

Replied by jelo on topic Sum a Multiple Numerical Input

socius wrote: I use the latest LTS and it says "Total"

You stated LS 2.6.4 LTS. The newest LTS is 2.6.6+ 171111. Looks really like an incomplete translation.

The meaning of the word "stable" for users
www.limesurvey.org/forum/development/117...ord-stable-for-users

Attachments:

...otalgesamt.PNG

The topic has been locked.

socius
Offline
Premium Member

More

6 years 8 months ago #164059 by socius

Replied by socius on topic Sum a Multiple Numerical Input

Hi jelo,

thanks! yes, you're right - I'm using LS 2.6.6-lts Build 171111 - I only used column sums and not the grand total, so I did not notice that there is both "Gesamt" and "Total" - is that to be filed as a "bug"? How could I help here? Seems that translations are a bit more complicated than just editing the .mo directly at github.com/LimeSurvey/LimeSurvey/blob/master/locale/de/de.mo - one has to edit the according .po with poedit.

Best, G

The topic has been locked.

l1bxr02
Offline
New Member

More

5 years 3 months ago #186700 by l1bxr02

Replied by l1bxr02 on topic Sum a Multiple Numerical Input

Hi there
I am working on adding multiple sums. I don't see Advanced settings to set the columns for addition. Can I get some help on how to do this? Thanks
Babu Ramabadran

The topic has been locked.