Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Want salary formula from absent days

Topic Labels: Formulas
Solved
Jump to Solution
449 1
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi, I want to how can i get remaining salary when employee I absent few days and from total salary the days he is absent should be excluded and formula gives me answer. Below are 3 tabs from which I need formula to be completed. Please help me.! @Gareth_Pronovost , W_Vann_Hall anyone please

Employee Tab
Absences Tab Salary Tab

1 Solution

Accepted Solutions

Hey! Is the absence and benefit data linked in the Employee table (I don’t see them)? if so, you should be able to grab those fields and make the pro-rated salary calculation. If you need them in separate tables (without links) you could use the scripting block here.

See Solution in Thread

1 Reply 1

Hey! Is the absence and benefit data linked in the Employee table (I don’t see them)? if so, you should be able to grab those fields and make the pro-rated salary calculation. If you need them in separate tables (without links) you could use the scripting block here.