Hi,
i have this formula working well, giving me the sum of Amount for the current year - which is sum from first of january till today.
I would like to have the same formula but for the prior year (2018) based on the maximum invoice date number of this year (2019). i tried to set it up, the one below but is not working.
Anyone can help?
Formula 2018 not working: should extract Amount from the first of january 2018 till today of 1 year ago
=Sum({<Invoice_Date_Num={">=$(=Num(YearStart(Max(Invoice_Date_Num), -1)))<=$(=Num(AddYears(Max(Invoice_Date_Num), -1)))"}>}Amount)
Formula 2019 working well
=Sum({<Invoice_Date_Num={">=$(=Num(YearStart(Max(Invoice_Date_Num))))<=$(=Max(Invoice_Date_Num))"}>}Amount)
