
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 31, 2025 06:51 AM
Hello,
I have a very simple formula that is taking the values calculated from other fields and giving a total. The problem I am running into is unless I have the formatting set to 5 decimal places the results will round. For the work we are doing we need the data to not round, but the issue is for the exports we have to do to input the data into another system we have to remove the extra decimal places. Is there a way to keep the 2 decimal place formatting while preventing the rounding?
For example if a value is 2543.54546 we would like it to be 2543.54, but if I change the formatting to two places the number ends up being 2543.55 which for reconciliation is a problem. The values change daily so the direction of rounding also changes.
My formula is super simple {value1} - {value2}
I did try adding the ROUND function, but that didn't seem to help at all.
I appreciate any help you all could offer.
Thank you
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 31, 2025 03:02 PM - edited ‎Jan 31, 2025 03:04 PM
Yes, the FLOOR parameter {significance} is not so simple (to be honest, I don't understand how it works).
Basically I'm using INT - it just outputs integer, throws out other part without rounding
So, do
INT(100*({value1}-{value2}))/100
Don't forget to set number of digits after point in Formatting.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 31, 2025 07:34 AM
It looks like the FLOOR function does what I need.
FLOOR({value1}-{value2},0.01)

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 31, 2025 08:58 AM
I thought the above was the answer, but i am encountering weirdness with it. So back to my original question.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 31, 2025 03:02 PM - edited ‎Jan 31, 2025 03:04 PM
Yes, the FLOOR parameter {significance} is not so simple (to be honest, I don't understand how it works).
Basically I'm using INT - it just outputs integer, throws out other part without rounding
So, do
INT(100*({value1}-{value2}))/100
Don't forget to set number of digits after point in Formatting.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 03, 2025 05:03 AM
This looks to take care of it. Thank you for helping.
