For the below formula, E and D is only for Indiana, she would like for E and D to work for all states
E=0.00; "E is Exemption Amount per Local Allowance"
D=0.00; "D is the Allowance Amount per Dependent"
M=0.00; "Maximum Tax (0 if no maximum)"
PERCENT=0.00000; "The value user entered for Locality %"
A=PRORATE((ANNUAL(ADJUSTED_GROSS)-(E*EMP_LOCAL_ALLOWANCES)-(D*EMP_LOCAL_NUMBER))*PERCENT%);
ANSWER=-IF(M=0,A,IF((ABS(YTD(Local_Tax)-Local_Tax)+A)>M,M-ABS(YTD(Local_Tax)-Local_Tax),A))
Guest
