Cumulative sum of hidden values in repeat group

Hi Lauren,

I think that you’d be able to use the sum function to sum the hidden
fields. Please refer to the wiki page here:
https://help.commcarehq.org/display/commcarepublic/CommCare+Functions#CommCareFunctions-sum

Let us know if you have any further questions.

Cheers,

··· -- Nate Haduch

Technical Support Analyst
Dimagi, Inc | 585 Massachusetts Ave | Suite 3 | Cambridge, MA 02139
web: http://www.dimagi.com/

On Fri, Dec 12, 2014 at 2:44 PM, Lauren lauren.a.theis@gmail.com wrote:

Hello everyone, I have been trying to search for this question in past
threads, but haven’t found it - I apologize if this has been asked before.

I am using a hidden value to calculate the amount of water that a
household uses each day, per water container (container capacity in liters

  • number of journeys to fetch water made in one day). This series of
    questions was made in a repeat group.

I would now like to make a new hidden value to calculate the total amount
of water (in liters) that a household uses each day, across all water
containers. Essentially, I want a cumulative sum of the hidden value
outputs in the repeat group. How can I do this? I appreciate any and all
help!

Thank you,
Lauren


You received this message because you are subscribed to the Google Groups
"commcare-users" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to commcare-users+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Ah, thank you! So simple I had missed it.

··· On Fri, Dec 12, 2014 at 2:51 PM, Nate Haduch wrote: > > Hi Lauren, > > I think that you'd be able to use the sum function to sum the hidden > fields. Please refer to the wiki page here: > https://help.commcarehq.org/display/commcarepublic/CommCare+Functions#CommCareFunctions-sum > > Let us know if you have any further questions. > > Cheers, > > -- > Nate Haduch > > Technical Support Analyst > Dimagi, Inc | 585 Massachusetts Ave | Suite 3 | Cambridge, MA 02139 > web: http://www.dimagi.com/ > > On Fri, Dec 12, 2014 at 2:44 PM, Lauren wrote: > >> Hello everyone, I have been trying to search for this question in past >> threads, but haven't found it - I apologize if this has been asked before. >> >> I am using a hidden value to calculate the amount of water that a >> household uses each day, per water container (container capacity in liters >> * number of journeys to fetch water made in one day). This series of >> questions was made in a repeat group. >> >> I would now like to make a new hidden value to calculate the total amount >> of water (in liters) that a household uses each day, across all water >> containers. Essentially, I want a cumulative sum of the hidden value >> outputs in the repeat group. How can I do this? I appreciate any and all >> help! >> >> Thank you, >> Lauren >> >> -- >> You received this message because you are subscribed to the Google Groups >> "commcare-users" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to commcare-users+unsubscribe@googlegroups.com. >> For more options, visit https://groups.google.com/d/optout. >> > > > > > -- > You received this message because you are subscribed to a topic in the > Google Groups "commcare-users" group. > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/commcare-users/BcXRL4laOZU/unsubscribe. > To unsubscribe from this group and all its topics, send an email to > commcare-users+unsubscribe@googlegroups.com. > For more options, visit https://groups.google.com/d/optout. >