Adding rounded numbers display value not typed in value | Community
Skip to main content
nowackem
nowackem
New Participant
August 11, 2021
Solved

Adding rounded numbers display value not typed in value

  • August 11, 2021
  • 2 replies
  • 657 views

How do I force a total field to add the displayed value sums of rounded fields? My display pattern for all the fields involved is this: num{zzzzzzzzzzzz9.9} so if the user types in 10.56, the field displays 10.6. Then in the second field the user types 10.285 but displayed as 10.3. The total (sum) is 10.8 because its adding 10.56 + 10.285 which equals 20.845 but rounding to 20.8. I want it to actually add 10.6+10.3 to equal 10.9. Do you see what I'm looking for? I need the formula to only add the displayed(rounded) value not the typed in value.

Thank you!

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Pulkit_Jain_

@nowackem 

To implement this use case, you can set value a couple of proxy/hidden fields [0] on the form to rounded field value(s) and then add the value of these fields to be displayed as output.

 

You may have to check which event will execute the sum operation script for the result field.

 

[0] - 

presence = "hidden";

 

2 replies

nowackem
nowackemAuthor
New Participant
August 12, 2021

Thank you!

    Pulkit_Jain_
    Pulkit_Jain_Accepted solution
    Employee
    August 12, 2021

    @nowackem 

    To implement this use case, you can set value a couple of proxy/hidden fields [0] on the form to rounded field value(s) and then add the value of these fields to be displayed as output.

     

    You may have to check which event will execute the sum operation script for the result field.

     

    [0] - 

    presence = "hidden";

     

      Terms & ConditionsAccessibility statement

      Loading footer...