Set Identifier

[#1]

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,

[hic]

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

[sunny_talwar]

May be this:

Sum( {$<ValueMonth = {$(#vMaxCycle)}, NarrationCat = {'Non Refund'}>} NrLoans)

/

Sum( {$<ValueMonth = {$(#vMaxCycle)}, NarrationCat = {'Non Refund'}>} TOTAL NrLoans)

[amit_saini]

try:

sum( {$<ValueMonth = {$(#vMaxCycle)} ,NarrationCat = {'Non Refund'} >} NrLoans )

/sum( {$<ValueMonth = {$(#vMaxCycle)} ,NarrationCat = {'Non Refund'}>} Total NrLoans )

Thanks,
AS

[#5]

Thanks everyone, it help... Now the expression is working.