limiting decimal places 1

[DanNorris2000]

Is there a way to limit the number of decimal places when using the sum function on a currency field?

sum(osloss)as OSLOS results in 4 decimal places. I would like to limit to 2 places

 

[dgrewe]

Have you looked into the Set Decimal command?

David W. Grewe
Dave@internationalbid.com
ICQ VFP ActiveList #46145644

 

[DSummZZZ]

Try using the ROUND() function. As in:

ROUND(sum(osloss), 2) as OSLOS

 

[foxdev]

Also SET FIXED.

Robert Bradley

http://www.foxdev.com/

 

[DanNorris2000]

osloss defined as currency 8

used the floowing statement:
round(sum(osloss),2) as oslos

resulted in 20 with 4 decimal places

 

[DSummZZZ]

Sorry, I wasn't paying attention to the fact you had said that it was a currency field. This should do what you need:

round(mton(sum(osloss)),2) as oslos

 

[DanNorris2000]

BINGO

thanks