(DECIMAL 17,2) 14.12345 --> 14.12

[vinaymanchinila]

Hi
I have an incomming decimal value (DECIMAL 17,2) say 14.12345 but I need just 2 places from the decimal like 14.12

I have tried to use the field function and extract the decimal portion of it so that I can append it to the value, but how do I extract the value before the delimter!

Thanks,

[ogmios]

As easier answer:
Ans = FMT(14.12345, 'R2')

Or

Ans = FMT(14.12345, 'T2')

First 1 rounds at 2, last one truncates at 2.

Ogmios

[vinaymanchinila]

Thanks so much for helping me out on the weekend!