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?
Solved! Go to Solution.
Topics help categorize Community content and increase your ability to discover relevant content.
Views
Replies
Total Likes
ROUND([your DIV calculation goes here],1)
Views
Replies
Total Likes
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
Views
Replies
Total Likes
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?
Views
Replies
Total Likes
ROUND([your DIV calculation goes here],1)
Views
Replies
Total Likes
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!
Views
Replies
Total Likes
Views
Likes
Replies
Views
Likes
Replies
Views
Likes
Replies
Views
Likes
Replies