Rounding Down

Questions and Answers about DataEase for Windows

Rounding Down

Postby SamT » Sun Sep 01, 2013 12:55 pm

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
SamT
 
Posts: 141
Joined: Sat Jan 16, 2010 12:09 pm
Has thanked: 0 time
Been thanked: 0 time
 

Re: Rounding Down

Postby KjetilUrne » Sun Sep 01, 2013 1:13 pm

floor ( FieldValue * 100) / 100
KjetilUrne
 
Posts: 602
Joined: Mon Oct 08, 2007 8:21 am
Location: Norway
Has thanked: 4 times
Been thanked: 1 time
 

Re: Rounding Down

Postby SamT » Sun Sep 01, 2013 1:58 pm

Thank you very much .That worked a treat !
Sam
SamT
 
Posts: 141
Joined: Sat Jan 16, 2010 12:09 pm
Has thanked: 0 time
Been thanked: 0 time
 
 

Return to DataEase for Windows

Who is online

Users browsing this forum: No registered users and 1 guest

cron