Rounding a Number in Calculated Field | Community
Skip to main content
T
ThomasNe2
Level 4
August 5, 2024
Solved

Rounding a Number in Calculated Field

  • August 5, 2024
  • 2 replies
  • 1245 views

I have added a Calculated Field into a Custom Form to divide two numbers added into the Form. This is working as expected.

But I would like to be able to display this number as either a whole number or to one decimal place using the Round or Floor expressions but haven't been able to get it to work as per the instructions in the Documentation area. 

Below is a screenshot of the current data expression and I wonder if someone would be able to help adding in one of the above functions to this expression?

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 skyehansen

ROUND([your DIV calculation goes here],1)

2 replies

Rafal_Bainie
Community Advisor
Rafal_BainieCommunity Advisor
Community Advisor
August 5, 2024

Round expression has 2 arguments: number itself & number of decimal places,e.g.

it works pretty well, although I vaguely recall I had some issues with rounding in the past that I don't remember clearly

 

T
ThomasNe2Author
Level 4
August 5, 2024

Hi Rafal - the number in this field differs with each Request submitted so I am unsure how to stipulate the actual number before the number of decimal places? 

 

skyehansen
Community Advisor
skyehansenCommunity AdvisorAccepted solution
August 5, 2024

ROUND([your DIV calculation goes here],1)

T
ThomasNe2Author
Level 4
August 6, 2024

Thanks for this Skye! I didn't realise I'd have to go back in and amend the details to get the values in the Calculated Field to update but this is working correctly now thank you!

 

Terms & ConditionsAccessibility statement

Loading footer...