Skip to main content
Solved

Prevent formula from rounding

J
  • J_C
  • Participating Frequently
  • 6 replies

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

Best answer by Alexey_Gusev

J_C wrote:

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.

View original
Did this topic help you find an answer to your question?

4 replies

J
  • J_C
  • Author
  • Participating Frequently
  • 6 replies
  • January 31, 2025

It looks like the FLOOR function does what I need.

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

 

J
  • J_C
  • Author
  • Participating Frequently
  • 6 replies
  • January 31, 2025
J_C wrote:

It looks like the FLOOR function does what I need.

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

 


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

Alexey_Gusev
Forum|alt.badge.img+12
  • Alexey_Gusev
  • Inspiring
  • 1113 replies
  • Answer
  • January 31, 2025
J_C wrote:

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
TheTimeSavingCo
2 people like this
  • J
    J_C
  • TheTimeSavingCo
    TheTimeSavingCo
J
  • J_C
  • Author
  • Participating Frequently
  • 6 replies
  • February 3, 2025
Alexey_Gusev wrote:

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.


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

Reply


Most helpful members this week

Terms & Conditions