Unable to Calculate YTD and LYTD

[SatyaPaleti]

Hi Friends,

I am having following data. Please find attachment.

I am calculating YTD and LYTD by following formulas, but my values are always showing 0

YTD :  sum({$<Year=,Month=, Date={'>=$(=YearStart(Max(Date)))<=$(=Max(Date))'}>}AMOUNT)

LYTD: sum({$<Year=,Month=, Date={'>=$(=YearStart(Max(Date), -1))<=$(=AddYears(Max(Date), -1))'}>}AMOUNT)

Thanks,

Satya

Please help me with this

[Vegar · Accepted solution]

Try changing to from single  t double quotation marks. Like this:

YTD :  sum({$<Year=,Month=, Date={">=$(=YearStart(Max(Date)))<=$(=Max(Date))"}>}AMOUNT)

LYTD: sum({$<Year=,Month=, Date={">=$(=YearStart(Max(Date), -1))<=$(=AddYears(Max(Date), -1))"}>}AMOUNT)

[SatyaPaleti · Accepted solution]

Thank you Vegar