Hello, I have a formula inserted into my crystal 10.0 report that is not working.
{Orders.TOTAL_CHARGES}/(345000) * 100
Basically, I'm looking for a percentage. When I insert the actual #'s - 365000 / 345000 * 100 - it calculates correctly (105%).
When I try and enter the order.total_charges field name in place of the actual # (so that I don't have to manually type the number in each time) it does not calculate correctly (.41%). Anyone have any thoughts? Thank you.
{Orders.TOTAL_CHARGES}/(345000) * 100
Basically, I'm looking for a percentage. When I insert the actual #'s - 365000 / 345000 * 100 - it calculates correctly (105%).
When I try and enter the order.total_charges field name in place of the actual # (so that I don't have to manually type the number in each time) it does not calculate correctly (.41%). Anyone have any thoughts? Thank you.