Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
this is my code on can you check this code is right or wrong?
Current
=if(GetSelectedCount(Date)>1,
Sum({<Date={">=$(=Date(Min(Date)))<=$(=Date(Max(Date)))"}>Sales),
Sum({<Date= {">=$(=DATE(YEARSTART(TODAY())))<=$(=DATE(TODAY()))"}>}Sales))
Previous
if(GetSelectedCount(Date)>1,
Sum({<Date={">=$(=Date(min(AddYears(Date,-1))))<=$(=Date(max(AddYears(Date,-1))))"}>}Sales),
Sum({<Date= {">=$(=DATE(YEARSTART(YEARSTART(TODAY())-1)))<=$(=DATE(AddYears(TODAY(),-1)))"}>} Sales))
HI,
what do you want to achieve with above exp? Could you pls elaborate a bit more.
Can use below expressions for CYTD & PYTD.
CYTD;
Sum({<={>=$(=Date(YearStart(Max(Date)))) <= $(=Date(max(Date)))}>}Sales)
CYTD;
Sum({<={>=$(=Date(YearStart(Max(Date),-1))) <= $(=Date(addyears(max(Date),-1)))}>}Sales)
Thanks,
Sasi