Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I created a flag field to indicate which rows are for the last 5 days of data (CEDateFlag = {1}). Is there a way to have this or something similar UNTIL other dates are selected from a list? At that point I would like it to show the selected dates until the selections are cleared.
IF([Amount/Count] = 'Count', Num(Sum($(vCollEff)CE0_30Cnt)/1000,'###K;(###K)'), Num(Sum($(vCollEff)CE0_30Amt)/1000000, '$###M;($###M)'))
Where $(vCollEff) = {$<CEDateFlag = {1},ReceiptType=,ReceiptStatus>}
may be use a If Condition if(GetSelectedCount(MyDate)>0,Num(Sum(CE0_30Cnt)/1000,'###K;(###K)')
,Num(Sum($(vCollEff)CE0_30Cnt)/1000,'###K;(###K)'))
hth
Sas
This may work, but it would require me to used nested if statements since my current expression uses one to determine if the chart should show counts or $ amounts.