Skip to main content

Hi All! We’re mid-migration so I have so many questions lately!

How do I add a calculated value to a SPO responsive form? I have a repeating section and in this repeating section I want to divide the cost by the number of people splitting the cost. my formula before on my old form was “sum(LegCost/LegPassengers])” When I try to add it now, there’s no calculated value field available to add so I inserted a number field and am adding the calculation to the default value. It’s looking like “sum(nSharePoint Columns].PLegCost]/mSharePoint Columns].PLegPassengers])” and it doesn’t calculate at all. Can you help me set this up?

Thank you!

Kassie

Hi Kassie

 

I’m not quite sure how you set up your repeating section so I may have misinterpreted your requirements.  As a general rule a form variable is the equivalent of a calculated value so here’s an example where I calculate the average cost per passenger.  I set up a repeating section with total passenger count and a total cost.

 

 

Now you can put that form variable into a label to display it on the form.  That form variable will also be available to you to reference later on in the workflow.  In addition, if you wanted to put it into another field, you can use a form rule to do that.

 

Cheers,

Chris

Fabulous! Thank you so much! Worked like a charm!

Reply


View our Community Site Map

Nintex Community Sitemap
Terms & ConditionsCookie settings