# Calculation Not Working Sort of

Question asked by dchabot on Apr 9, 2013
Latest reply on Apr 10, 2013 by dchabot

Hi,

I got this great calculation from David Jondreau for use in a Payroll file.

It calculates taxable wages based on a maximum amount.

For example: FICA Wages taxable currently max at 113,700.

The calculation works fine until a person gets to the max, then the next paycheck starts deducting a fica tax from

the YTD. Can anyone see what might be going wrong?

Here's the calc for FICA WAGES TAXABLE:

Let([

//Gross Pay YTD is the sum of all pay including this week's. So let's subtract this week's pay and get all pay up until this one.

prevPay = Gross Pay YTD - Gross Pay ;

//what wiggle room do we have between our old pay and max wages?

availablePay = 113700 - prevPay ;

//but let's not let that number be less than zero

availablePay = Max ( availablePay ; 0 ) ;

//which is less, available or actual pay?

taxable = Min ( availablePay ; Gross Pay )

];

taxable

) //End Let

Thanks so much!

Deb Chabot

FM 11A on MacsML