Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
Thank you Vegar
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)
Thank you Vegar