I thought you might go there!!!! Dennis McGrath Software Developer QMI Security Solutions 1661 Glenlake Ave Itasca IL 60143 630-980-8461 [email protected] ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Monday, December 19, 2011 2:19 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Decimal places in a report
Thanks so much, Dennis! This is what I ended up using. This will display 2 decimal places for those numbers with no or 1 decimal, and will display however many more than 2 it might have: (IFGT(MOD((PriceEach * 100),1),0, CTXT(PriceEach),FORMAT(PriceEach,'990.00'))) Karen In a message dated 12/19/2011 1:46:52 PM Central Standard Time, [email protected] writes: (IFGT(MOD((`Price Each` * 100),1),0,FORMAT(`Price Each`,'990.0000'),FORMAT(`Price Each`,'990.00'))) Dennis McGrath Software Developer
