I am trying to use the nested if statement and got this error message
""you may have entered a comma without a preceding value or identifier"
Here's the query:
Revised Cost: IIf((AND([Total Cost]![EXP_CAT]="PAYROLL”, [Total Cost]![EXP_TYPE]="A” )),0,(iif((AND([Total Cost]![EXP_CAT]="PAYROLL”, [Total Cost]![EXP_TYPE]="B”)),0,[Total Cost]![SumOfACT])))
I have a table "Total Cost", if Exp_Cat=Payroll and "Exp_Type"=A or B, set the revised cost to "0", otherwise set cost ="SumofAct".
What went wrong? Please help. Thanks!