AnsweredAssumed Answered

Sum for a specific year

Question asked by gremlin9297 on May 18, 2015
Latest reply on May 20, 2015 by gremlin9297

Title

Sum for a specific year

Post

Hello again my friends,

I have a portal that represents the number of days taken throughout employment, so it spans several years. My goal is to sum the sick days of just the current year excluding any previous years count. The attached is the current calculation im using... problem is that it either looks at one one records date instead of all of them and the calculation fails or it sums everything instead of the specific date. Thanks in advance for any help. 

Sick_Total.png

Outcomes