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
|Date||Choice (drop down menu)||Value|
Is this possible?
Solved! Go 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.
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?
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.