AnsweredAssumed Answered

calculate totals based on a value list

Question asked by m.mcdonell on Jan 9, 2018
Latest reply on Jan 9, 2018 by jbrown

I have a simple Employee time sheet with a value list that has 'vacation and sick' as the two choices. I have another field for total days. I am using a portal that gives me a line for each block of time and on that line I can choose the type of time off and enter the total days for that block.

Example: Employee 1 takes January 5-7 off as vacation (3 days), January 10 as sick (1 day) and January 14 as vacation (1 day).

 

I am looking for a calculation to return (4 vacation and 1 sick day used)

 

Suggestions?

Thanks in advance, I am sure this is fairly easy but I am stuck.

Outcomes