LYTD

[Anonymous]

=Sum({<INSTALL_DATE={">=$(=Date(YearStart(Max(today()),-1)))<=$(=Date(addyears(Max(today()),-1))) "}>}[2017Liquidations])

Hello. My LYTD function is returning the whole year sum. How can I fix this?

[sunny_talwar · Accepted solution]

May be try this

=Sum({<INSTALL_DATE = {">=$(=Date(YearStart(Today(), -1)))<=$(=Date(AddYears(Today(), -1)))"}>} [2017Liquidations])