DblWide Posted January 5, 2004 Share Posted January 5, 2004 I created a calculation field to track annual vacation and sick leave (previous yr balance + earned leave - used leave = new balance) and it is working just fine. However, for vacation time, we are only allowed to carryover a maximum of 48 days. What do I add to the calc to get a result no > 48? Link to comment Share on other sites More sharing options...
John Caballero Posted January 5, 2004 Share Posted January 5, 2004 (Case(previous yr balance>48,48,previous yr balance) + earned leave - used leave) Link to comment Share on other sites More sharing options...
CobaltSky Posted January 6, 2004 Share Posted January 6, 2004 Hi Dblwide, I suggest that you use something along the lines of: Min(48, PreviousBalance) Link to comment Share on other sites More sharing options...
DblWide Posted January 6, 2004 Author Share Posted January 6, 2004 Thanks to John and Ray for your replies. I still need help. The "previous balance" field is already <= 48. I need the "new balance" that the calculation field is calculating to be no greater than 48. I tried modifications of your suggestions to get this to work, but I can't get it right. Any other suggestions? I. E: previous balance = 48 days, + earned 15 days, - used 10 days, new balance is still 48 not 53. Link to comment Share on other sites More sharing options...
-Queue- Posted January 6, 2004 Share Posted January 6, 2004 So Min( 48, previous yr balance + earned leave - used leave ) doesn't work for you? Link to comment Share on other sites More sharing options...
DblWide Posted January 6, 2004 Author Share Posted January 6, 2004 THANKS! Now I get it! Problem solved. You are my heros! Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7409 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now