Forum Discussion
Running Total using active and inactive relationship
Hi I'm trying to determine the running total of [hours/week] displayed by month/year. The basic algorithm is RunningTotal = sum hours/week ( joined <= current and exit date is blank) + sum hours...
Anonymous , refer if this HR blog can help
lbendlin
Super User
Super UserYou seem to be on the right track. what has helped me is copious amounts of variables, breaking the problem into logical steps, and then using CONCATENATEX to validate the variables are actually doing what I want them to do for each of the steps.