Edit Expression Less than 'Today()'

logistici — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Edit Expression Less than 'Today()'

PrashantSangle — Fri, 17 Nov 2017 09:43:24 GMT

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