sum repeating section base on dropdown choice

[jasongci]

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

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

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

Is this possible?

[mlauer · Accepted 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

[jasongci]

Perfect.  Thanks for your help.

[#4]

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

[nzuser1]

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.

[nj]

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