Edit Expression Less than 'Today()'

[logistici]

Hello,

I have a question concerning dates.

I want to have a text object with specific filters.

I want to have the sum of NETLINEVAL for the previous Year until TRNDATE AddYears(Today(),-1).

=Sum({1<YEARR={'$(=Year(Today())-1)'},TRNDATE={"<=$(=AddYears(Today(),-1))"} >} NETLINEVAL)

Unfortunatly, it doesn't work. I don't have the right results.

Regards.

[PrashantSangle]

Hi,

check your date format if "TRNDATE" and "=AddYears(Today(),-1)"

Are you calculating PY-YTD

=Sum({1<YEARR={'$(=Year(Today())-1)'},TRNDATE={">=$(=date(YearStart(Today(),-1)))<=$(=date(AddYears(Today(),-1)))"} >} NETLINEVAL)

Regards,

Prashant