Forum Discussion

etuckeriv's avatar
etuckeriv
Frequent Visitor
5 years ago
Solved

Quarter and Week Aging

I have a fiscal calendar lookup table that I'm looking to create a couple of extra calculations in, but I can't seem to figure out how to get them to do what I need.   What I need are what my compa...
  • etuckeriv's avatar
    etuckeriv
    5 years ago

    This actually turned out to be pretty simple. All I ended up doing was subtracting the Week/Quarter Index Number from the current Quarter/Week Index Number with this formula:

     

    =FiscalCalendarTable[QuarterIndex]-LOOKUPVALUE(FiscalCalendarTable[QuarterIndex],FiscalCalendarTable[Today?],TRUE)

     

    Thanks for the guidance, everyone! I learned about a couple new functions while reverse engineering Greg's solutions below!

etuckeriv's avatar
etuckeriv
Frequent Visitor
5 years ago

This actually turned out to be pretty simple. All I ended up doing was subtracting the Week/Quarter Index Number from the current Quarter/Week Index Number with this formula:

 

=FiscalCalendarTable[QuarterIndex]-LOOKUPVALUE(FiscalCalendarTable[QuarterIndex],FiscalCalendarTable[Today?],TRUE)

 

Thanks for the guidance, everyone! I learned about a couple new functions while reverse engineering Greg's solutions below!