Forum Discussion

SidFontoura's avatar
SidFontoura
Qrew Member
4 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 consumed the previous fiscal year (in case there is any carry over).

Fiscal years go 1 Jan to 31 Dec, so I want to calculate a sum from TODAY to 1 Jan of the previous year.

------------------------------
Sid Fontoura
------------------------------
Formulas and functions
Relationships
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    4 years ago
    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
      4 years ago
      Of course!  Thank you for your help!

      ------------------------------
      Sid Fontoura
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        4 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
        ------------------------------