Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
i'm trying to calculate the QoQ when selecting multiple Qtrs,
i have managed to it using this formulas:
if((QuarterStart(today())=max(QuarterDateStart) and GetPossibleCount([Quarter-Year])=1) or (GetSelectedCount(Year)=0 and GetSelectedCount([Quarter-Year])=0 and QuarterStart(today())=max(QuarterDateStart)),
sum({< [Qtr Diff] = {"$(=max([Qtr Diff]))"} >}(COUNT_FULL_PATH))
/
Sum({<QuarterDateStart=$(vMaxDatePY),QTD={'QTD'} >}(COUNT_FULL_PATH)),
if((GetPossibleCount([Quarter-Year])=2),
sum((COUNT_FULL_PATH))
/
(Sum({<QuarterDateStart=$(vMaxDatePY)>}(COUNT_FULL_PATH))
+
Sum(QuarterDateStart=$(vMinDatePY)>}(COUNT_FULL_PATH))
),
if((GetPossibleCount([Quarter-Year])=4) or GetSelectedCount(Year)=1 ,
sum((COUNT_FULL_PATH))
/
Sum({<Year={"$(=(max(Year)-1))"}>}(COUNT_FULL_PATH)),
if((GetPossibleCount([Quarter-Year])=3),
0,
sum({<QuarterDateStart=$(vMaxDate) >}(COUNT_FULL_PATH))
/
Sum({<QuarterDateStart=$(vMaxDatePY)>}(COUNT_FULL_PATH))))))
i'm stuck on the selecting 3 Qtrs part, i'm not sure how to create the formula,
or maybe there's an easier way to do all that?
help is much appreciated!!!
help is much appriciated