Skip to main content
Answer

Round currency DOWN to nearest dollar in GI

  • April 7, 2023
  • 2 replies
  • 217 views
M
Semi-Pro II
Forum|alt.badge.img

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

2 replies

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

Hi @mikeho ,

You can use the floor function for this purpose.   

=floor([SOOrder.CuryLineTotal])

Hope this helps!

Laura

Laura - https://www.linkedin.com/in/laura-jaffe-965a411a/ ~ If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
darylbowman
robk20
kdavis45
M
Semi-Pro II
Forum|alt.badge.img
  • michaelho
  • Author
  • Semi-Pro II
  • 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.

lauraj46
Chris Hackett
Terms & ConditionsCookie settingsAccessibility statement
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved