I created the following formula which works just fine in a report. When I try to duplicate/copy formula I get the error message "a statement is expencted here" right after the THEN stmt, where it doesn't do it in original formula. Also now all my if statements seem to be getting the same error (new) I don't know if I'm burned out on this,but please help with formula
IF {PRM_MASTER__EMPLOYEE.Union_Class} = "PA" THEN 1.30
ELSE
IF {PRM_MASTER__EMPLOYEE.Union_Class} = "O" THEN 2.30
ELSE
IF {PRM_MASTER__EMPLOYEE.Union_Class} = "A1" THEN 2.30
ELSE
IF {PRM_MASTER__EMPLOYEE.Union_Class} = "A2" THEN 2.30
ELSE
3.30
this is the formula I created and it works fine in the first report but not the second one