Skip to main content
Nintex Community Menu Bar
Solved

SharePoint Online Responsive form Calculated Value

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

View original
Translate
Did this topic help you find an answer to your question?

2 replies

Chris_Ben
Nintex Employee
Forum|alt.badge.img+14
  • Chris_BenNintex Employee
  • Nintex Employee
  • 357 replies
  • 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

Translate
SimonMuntz
kmccool
2 people like this
  • SimonMuntz
    SimonMuntz
  • kmccool
    kmccool
kmccool
Forum|alt.badge.img+9
  • kmccool
  • Author
  • Scholar
  • 102 replies
  • July 15, 2024

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

Translate
Chris_Ben
1 person likes this
  • Chris_Ben
    Chris_Ben

Reply


Sidebar Buttons
Nintex Community Home Contact Nintex Support Email Nintex Community Check Nintex Status
Terms & ConditionsCookie Settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie Settings