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!!!!!!
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you so much!!! Never thought to go from number to string to number.
http://www.kenhamady.com/form22.shtml
mlmcc