I know there's a way to do this, but nothing I've tried is working.
Trying to make a formula to calculate/post work comp expense/liability with payroll that is run each week.
In TN, 1/3 of overtime is exempt; and consider in this example that the w/c rate is .033325.
This is the formula I've tried in many different iterations: ANSWER=-(((ADJUSTED_GROSS)-(Overtime*.3333))*.033325)