trying to add a numeric formula into a saved search to generate results that save manual calculation time. i am trying to put in a formula that divides the reference field by a set number if the reference is greater than 0. The reference field will either be blank or have a numeric value in it. here is the formula i have entered and i keep getting an error message that says invalid expression:
CASE WHEN {custbody_cbms} > '0' THEN ({custbody_cbms}/2.27) END
Any help on how to get this done would be greatly appreciated.
thanks!