Skip to main content
Nintex Community Menu Bar
Solved

SharePoint Online Responsive form Calculated Value

  • July 15, 2024
  • 2 replies
  • 137 views
kmccool
Forum|alt.badge.img+9

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([SharePoint Columns].[LegCost]/[SharePoint Columns].[LegPassengers])” and it doesn’t calculate at all. Can you help me set this up?

Thank you!

Kassie

Best answer by Chris_Ben

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

2 replies

Chris_Ben
Nintex Employee
Forum|alt.badge.img+14
  • Chris_BenNintex Employee
  • Nintex Employee
  • Answer
  • July 15, 2024

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

SimonMuntz
kmccool
kmccool
Forum|alt.badge.img+9
  • kmccool
  • Author
  • Scholar
  • July 15, 2024

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

Chris_Ben
Sidebar Buttons
Nintex Community Home Contact Nintex Support Email Nintex Community Check Nintex Status
Terms & ConditionsCookie SettingsAccessibility statement