4 Replies Latest reply: Jul 19, 2016 8:46 AM by Treasure Dlamini

# Set Identifier

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,

• ###### Re: Set Identifier

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

• ###### Re: Set Identifier

May be this:

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

/

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

• ###### Re: Set Identifier

try:

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

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

Thanks,
AS

• ###### Re: Set Identifier

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