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?
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
You can use the floor function for this purpose.
=floor([SOOrder.CuryLineTotal])
Hope this helps!
Laura
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.