Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I calculated the YoY Growth like so:
(sum({<[Qtr Diff] = {"$(=max([Qtr Diff]))"}>}(COUNT_U_SHAPED))
-
sum({< QTD = {'QTD'}, QuarterDateStart=$(vMaxDatePY)>}(COUNT_U_SHAPED)))
/
sum({< QTD = {'QTD'}, QuarterDateStart=$(vMaxDatePY)>}(COUNT_U_SHAPED))
and it works great. but when changing the date, i get "-".
how can i overcome this? make it adjustable for picking different Qtr-Year?
thank you!