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