Help

Want salary formula from absent days

Topic Labels: Formulas
Solved
Jump to Solution
737 1
cancel
Showing results for 
Search instead for 
Did you mean: 
ibrahim_shaukat
5 - Automation Enthusiast
5 - Automation Enthusiast

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
andywingrave
10 - Mercury
10 - Mercury

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
andywingrave
10 - Mercury
10 - Mercury

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.