Hello Everyone,
I hope Monday is off to a good start for everyone.
Question: Setting up a "Calculated Value." I'm using two "Single Line Textboxes" to multiply two numbers, to come to an "Annual Savings" Calculated Value. I put the amount in, yet the amount does not calculate or return in the "Annual Savings" Control.
Thoughts?
Thanks!
+16
Hi @Underdog
The Annual Savings will NEVER show on the form as the values have yet to be saved into the SPO List.
What you are showing is SPO columns settings.
Are you are using SPO Calculated Value? Is this what you want?
The SPO calculated function will only do the "calculation" once the form is submitted (the 2 fields value saved into SPO)
Here is how to create the SPO Calculated Field
Initially, I would like the calculation to show up on the Form. For instance, in an area preceding my problem, the calculation process works and shows on the Form. I would like that to work the same further down the Form.
This is where it works on the Form:
This where I would like it to work on the Form (where it is not calculating, and I cannot figure out why):
+16
Hi @Underdog
Create a Variable to store the calculated value.
Add the following to make the Problem Reduction value as a Percentage (x/100)
Add a Label control.
Insert the recently created Variable
Preview the form. Test with some values
Cheers
Where does the "Form" come from? I see the "Named Controls" Annual Audit Savings & Problem Reduction.
+16
HI @Underdog
Oops! sorry mate.
That is from the New Responsive form. Which form are you using?
Responsive or Classic?
Use the Named controls.
I'm using a Calculated Value control to display the calculations
Hope this helps
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.