Link to home
Start Free TrialLog in
Avatar of PEAKTT
PEAKTT

asked on

Round a decimal value to the nearest quarter in Crystal Reports XI

I have a decimal value that I am pulling into a Crystal Report.  That value is then divided by 2.  After that I need to round it up to the nearest quarter.

Example:
The value of the field is 2.75
I divide that by 2 to get 1.37
I now need to round it up to 1.5 to be at the next quarter amount.

Any help will be greatly appreciated!!!!!!
ASKER CERTIFIED SOLUTION
Avatar of wykabryan
wykabryan
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Mike McCracken
Mike McCracken

You could modify this formula
http://www.kenhamady.com/form22.shtml

mlmcc
Avatar of PEAKTT

ASKER

Thank you so much!!!  Never thought to go from number to string to number.