Skip to main content

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?

Hi @mikeho ,

You can use the floor function for this purpose.   

=floor(oSOOrder.CuryLineTotal])

Hope this helps!

Laura

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


Terms & ConditionsCookie settings
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