Page 1 of 1

Rounding Down

PostPosted: Sun Sep 01, 2013 12:55 pm
by SamT
Hello chaps
DFW 6.52 flavour .Please can someone steer me the right way.
I am trying to create a field that is a number that rounds down so i can export the value to Sage. It's a VAT value .
For example the calculated value is 12,348 and I want to export out 12.34
Thanks for your help
Sam

Re: Rounding Down

PostPosted: Sun Sep 01, 2013 1:13 pm
by KjetilUrne
floor ( FieldValue * 100) / 100

Re: Rounding Down

PostPosted: Sun Sep 01, 2013 1:58 pm
by SamT
Thank you very much .That worked a treat !
Sam