Help

The Community will be undergoing maintenance from Friday February 21 - Friday, February 28 and will be "read only" during this time. To learn more, check out our Announcements blog post.

Re: Prevent formula from rounding

Solved
Jump to Solution
277 1
cancel
Showing results for 
Search instead for 
Did you mean: 
J_C
5 - Automation Enthusiast
5 - Automation Enthusiast

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. 

 
ROUND({value1}-{value2},5)
I tried various values for the precision and none of them did what I needed.

I appreciate any help you all could offer.

Thank you

1 Solution

Accepted Solutions

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.

See Solution in Thread

4 Replies 4
J_C
5 - Automation Enthusiast
5 - Automation Enthusiast

It looks like the FLOOR function does what I need.

FLOOR({value1}-{value2},0.01)

 

J_C
5 - Automation Enthusiast
5 - Automation Enthusiast

I thought the above was the answer, but i am encountering weirdness with it.  So back to my original question.

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.

J_C
5 - Automation Enthusiast
5 - Automation Enthusiast

This looks to take care of it.  Thank you for helping.