Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
Please see below image, Total column calculate 0 (ZERO) against some branches. Which is wrong, it suppose to give me total.
My Expression is below
if(vFromDate >= Sdate1,sum({<T_Date= {'>=$(vFromDate) <=$(vToDate)'} >}Tday),
aggr(sum(if(T_Date>=Sdate1 and T_Date <= vToDate ,Tday)), DECDDT1,Sdate1, Branch, [Branch Name],[RSM Name]))
Is anything wrong/modify in expression?
Please Anybody Can Help!!!
Vinay
aggr(
if(vFromDate >= Sdate1
,sum({<T_Date= {'>=$(vFromDate) <=$(vToDate)'} >}Tday),
sum(if(T_Date>=Sdate1 and T_Date <= vToDate ,Tday)),
DECDDT1,Sdate1, Branch, [Branch Name],[RSM Name])