Skip to main content
Solved

Round currency DOWN to nearest dollar in GI


Forum|alt.badge.img+1

Is it possible in a GI to round a value DOWN to the nearest dollar? If I try using the available “Round( x, decimals)” function it will only round UP to the nearest dollar.

Anyone have any workarounds for this?

Best answer by lauraj46

Hi @mikeho ,

You can use the floor function for this purpose.   

=floor([SOOrder.CuryLineTotal])

Hope this helps!

Laura

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

2 replies

lauraj46
Captain II
Forum|alt.badge.img+8
  • Captain II
  • 505 replies
  • Answer
  • April 7, 2023

Hi @mikeho ,

You can use the floor function for this purpose.   

=floor([SOOrder.CuryLineTotal])

Hope this helps!

Laura


Forum|alt.badge.img+1
  • Author
  • Semi-Pro II
  • 228 replies
  • April 13, 2023

Thanks, @lauraj46! That got me most of the way there. I’m doing some grouping in the GI and that was causing some issues that I had to work out. Also, I’m working with the ARTran.NetSalesAmount field so I had to convert any negative values to positive first before using the Floor function, and then convert them back to negative. But I think I have it all squared away now.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings