cancel
Showing results for 
Search instead for 
Did you mean: 
jasongci
Nintex Newbie

sum repeating section base on dropdown choice

Jump to solution

I have a repeating section with a value filed and what I would like to to is to calculate the total depending on the drop down menu choice

eg

DateChoice (drop down menu)
Value
11/06/2015Flight£10.00
11/06/2015Taxi£10.00
11/06/2015Flight£20.00

Choice
Total
Flight£30.00
Taxi£10.00
Grand total£40.00

Is this possible?

Labels: (2)
Reply
5 Replies
mlauer
Nintex Newbie

Re: sum repeating section base on dropdown choice

Jump to solution

For each value of Choice You have to add a calculated value controle to repeating section named e.g. val_flight and val_taxi with formula If(equals(Choice,'Flight'),Value,0) and If(equals(Choice,'Taxi'),Value,0).

Under Repeating section add for each value of Choice a calculated value control with formula e.g. sum(val_flight).

If You would not show the extra columns in repeating section You can set it to invisible using css.

Kind regards

Manfred

Reply
jasongci
Nintex Newbie

Re: sum repeating section base on dropdown choice

Jump to solution

Perfect.  Thanks for your help.

Reply
Not applicable

Re: sum repeating section base on dropdown choice

Jump to solution

Hi Manfred,

I use this tutorial to create a form, the form has two repeating section (which need to sum data based on choice field),I have got this problem when I have just one repeating section everything work fine but when I add another repeating section the form does not send data to my SharePoint columns (because I connect each calculated value (I meant the sum(val_flight)) to specific column).

Do you have any experience?

Thanks

0 Kudos
Reply
nzuser1
Nintex Newbie

Re: sum repeating section base on dropdown choice

Jump to solution

Hi,

Manfred Lauer

What if the amount of choices is very large? what would be the best method of getting this functionality.

In this example, the choices are only flight and taxi, but what I am working on, there are more than 100's of choices. I am looking to show something similar, but only the choices that the user picks show up in the final total.

Any help would be greatly appreciated.

0 Kudos
Reply
nj
Nintex Newbie

Re: sum repeating section base on dropdown choice

Jump to solution

Did you ever figure out a way to do this? I'm looking to do the same thing, with about 80 choices. 

0 Kudos
Reply