Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi There,
I would to add an a filter on the expression below :
sum( {$<ValueMonth = {$(#vMaxCycle)} >} NrLoans )
/sum( {$<ValueMonth = {$(#vMaxCycle)} >} Total NrLoans )
what I would like to add : NarrationCat = 'Non Refund'
Thanks,
If you want this ratio just for 'Non Refund', you should use
sum( {$<ValueMonth = {$(#vMaxCycle)} , NarrationCat = {'Non Refund'} >} NrLoans )
/sum( {$<ValueMonth = {$(#vMaxCycle)} , NarrationCat = {'Non Refund'} >} Total NrLoans )
However, if you instead want to see the ratio of 'Non Refund' as compared to all, you should use
sum( {$<ValueMonth = {$(#vMaxCycle)} , NarrationCat = {'Non Refund'} >} NrLoans )
/sum( {$<ValueMonth = {$(#vMaxCycle)} >} Total NrLoans )
HIC
May be this:
Sum( {$<ValueMonth = {$(#vMaxCycle)}, NarrationCat = {'Non Refund'}>} NrLoans)
/
Sum( {$<ValueMonth = {$(#vMaxCycle)}, NarrationCat = {'Non Refund'}>} TOTAL NrLoans)
try:
sum( {$<ValueMonth = {$(#vMaxCycle)} ,NarrationCat = {'Non Refund'} >} NrLoans )
/sum( {$<ValueMonth = {$(#vMaxCycle)} ,NarrationCat = {'Non Refund'}>} Total NrLoans )
Thanks,
AS
Thanks everyone, it help... Now the expression is working.