topic Re: Issue in LYTD and YTD expression in App Development

Issue in LYTD and YTD expression

priyanka08 — Fri, 23 Sep 2022 11:35:41 GMT

My below LYTD expression

num(sum({<Month,Year,YearMonth,date ={">=$(vLastYearStart) <=$(vLastYear)"}>}Sales) ,'##0.0')

It will give data will may-21 .Even if I select jun-22

Similarly for YTD

num(sum({<Month,Year,YearMonth,date ={">=$(vYearStart) <=$(vMaxDate)"}>}Sales) ,'##0.0')

It will give data will may-22 .Even if I select jun-22

But if I put space before below bold it will give all month data ir-respective of selection

num(sum({<Month,Year,YearMonth,date ={">=$(vYearStart) <= $(vMaxDate)"}>}Sales) ,'##0.0')

BrunPierre — Fri, 23 Sep 2022 16:43:00 GMT

How about this.

YTD
Sum({$<[Date] = {'>=$(=YearStart(Today()))'}>} [Sales])

YTD Previous Year

Sum({$<[Date] = {'>=$(=Date(AddYears(YearStart(Today()),-1)))<$(=Date(AddYears(Today(),-1)))'}>} [Sales])

priyanka08 — Mon, 26 Sep 2022 12:40:34 GMT

This is also give same result.Not working at all.

BrunPierre — Mon, 26 Sep 2022 17:57:08 GMT

Could you perhaps clarify this?

" But if I put space before below bold it will give all month data ir-respective of selection ..."