I ma facing problem while calculating
(WTD/LWTD-)1 i.e. growth over last year
I am using this experssion
Sum({<Year=, Num_Month=, Week=, [Walkin Date]=, WalkinDateNum={">=$(=Num(MonthStart(Max(WalkinDateNum))))<=$(=Max(WalkinDateNum))"}>} Incount)+
Sum({<Year=, Num_Month=, Week=, [Walkin Date]=, WalkinDateNum={">=$(=Num(MonthStart(Max(WalkinDateNum))))<=$(=Max(WalkinDateNum))"}>} OutCount))/2))/
(Count(distinct {<PostingDateNum={'>=$(vPriorMinDate)<=$(vPriorMaxDate)'}, Year=,Num_Month=>} if(TrnType='2100',Bill_No_Distinct))
/
((Sum({<Year=, Num_Month=, Week=, [Walkin Date]=, WalkinDateNum={">=$(=Num(YearStart(vMinPriorWalkin)))<=$(=(vMaxPriorWalkin))"}>} Incount)+
Sum({<Year=, Num_Month=, Week=, [Walkin Date]=, WalkinDateNum={">=$(=Num(YearStart((vMinPriorWalkin))))<=$(=(vMaxPriorWalkin))"}>} OutCount))/2)))
-1,
