Solved

calculate sick leave, paid holiday filemaker

Posted on 2007-04-02
2
1,329 Views
Last Modified: 2008-02-01
my company gives paid holiday after 3 month start... earn 0.55day every month.
second year... 0.84day...
sick day 0.5 day... even next year..
Paid holiday max is 20 days and sick is 10 days..
i need to calculate these numbers... do you know how to do it?
0
Comment
Question by:Hiroyuki Tamura
2 Comments
 
LVL 19

Accepted Solution

by:
billmercer earned 125 total points
ID: 18839767
Assuming your company uses the date of hire to determine when the paid holiday is updated, you could use a CASE() statement to calculate what the monthly accrual is for each person.
It might look like this:
Case(
   currentdate - startdate >= 365; .84;
   currentdate - startdate < 365 and currentdate - startdate > 90 ;    .55 ;
   currentdate - startdate < 30; 0;
  -1
)

Then, once per month you run a script which adds this amount to the person's vacation hour total, subtracts any time actually used, and uses the MIN() function to set the hours to the lower of the current total or the number 20, like this.

   CurrentHours = Min( CurrentHours; 20 )

Simply do the same thing for the sick time, using appropriate values there. The case statement will be simpler because you will only have to test for the one year.


0
 

Author Comment

by:Hiroyuki Tamura
ID: 18841110
thank you.
0

Featured Post

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

Pop up windows can be a useful feature of any Filemaker database.  Though best used sparingly, they can be employed in a multitude of different ways, for example;  as a splash screen at login, during scripted processes to control user input, as pick…
Having just upgraded from Filemaker 11 to Filemaker 12 over the weekend, we thought we would add some tips for others making the same move.  In general, our installation went without incident. Please note that this is not a replacement for Chapter 5…
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now