Forum Discussion

SidFontoura's avatar
SidFontoura
Qrew Member
3 years ago

Calculating a sum of vacation days used this fiscal year back to previous fiscal year start

I am trying to calculate an employee's owed vacation days. I want to make sure I capture all of the days they might be owed, so I want to include the total used this fiscal year plus the total consume...
Formulas and functions
Relationships
MarkShnier__You's avatar
MarkShnier__You
Qrew Champion
This is a summary filter or a report filter you can use the same technique.  
when
 ANY of 

[date] is during the current year
[date] is during the previous year.

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
SidFontoura's avatar
SidFontoura
Qrew Member
3 years ago
Of course!  Thank you for your help!

------------------------------
Sid Fontoura
------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Qrew Champion
    3 years ago
    ya "During" is handy.

    As an aside, if you only wanted to get totals from two years ago but not last year you do this kind of filter  

    ALL of
    date is during the previous 2 years
    date is not during the current year


    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------