Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Am having a requirement like the filter selection wont effect the value inside the text object like if the user selects an month the text object won't reflect
Maybe you need {1} in the denominator expression as well:
=Num(Count({1<[ApplicationStatus] ={'Approved'},FiscalYear={'2016-2017'}>} DISTINCT ApplicationNbr)/Count(DISTINCT({1} ApplicationNbr)), '##.00%')
Hi,
For below expressions,
=Count( Aggr(Count(DISTINCT racApplicationNbr), racCustomerID, racApp_Date))
Below logic is't working ,
if(FiscalYear='2016-2017',Count(Aggr(Count(DISTINCT racApplicationNbr), racCustomerID, racApplication_Date)))
It seems you are just adding new requirements to the existing post. Can you please create new threads for new requirements and close this one my marking correct and helpful answers?
Hi,
The below expression is for same issue,
=Count( Aggr(Count(DISTINCT racApplicationNbr), racCustomerID, racApp_Date))
Thanks..