Expression

[#1]

Hi Community,

Can we write the below expression in on line

Total Exposure = sum({<BS_TYPE ={'OFB'},%Month = {'$(=$(=vPrevMonth))'}, %Year = {'$(=$(=vPrevYear))'}>}EAD)+
sum({<BS_TYPE ={'ASS'},%Month = {'$(=$(=vPrevMonth))'}, %Year = {'$(=$(=vPrevYear))'}>}EAD)+
sum({<BS_TYPE -={'ASS','OFB'},%Month = {'$(=$(=vPrevMonth))'}, %Year = {'$(=$(=vPrevYear))'}>}EAD)

Thank you

[Gysbert_Wassenaar]

sum({<%Month = {'$(vPrevMonth)'}, %Year = {'$(vPrevYear)'}>}EAD)

[sunny_talwar]

Or may be this:

=Sum({<BS_TYPE = ,%Month = {'$(vPrevMonth)'}, %Year = {'$(vPrevYear)'}>}EAD)

[#4]

Hi Gysbert,

Thanks for the reply..

But I have another BS_Type like  BS_Type='XYZ' and so on... I don't wanted to include those

[Gysbert_Wassenaar · Accepted solution]

You already did in your original expression:

Total Exposure =

Only OFB: sum({<BS_TYPE ={'OFB'},%Month = {'$(=$(=vPrevMonth))'}, %Year = {'$(=$(=vPrevYear))'}>}EAD)+

Only ASS: sum({<BS_TYPE ={'ASS'},%Month = {'$(=$(=vPrevMonth))'}, %Year = {'$(=$(=vPrevYear))'}>}EAD)+

Everything that's not OFB or ASS: sum({<BS_TYPE -={'ASS','OFB'},%Month = {'$(=$(=vPrevMonth))'}, %Year = {'$(=$(=vPrevYear))'}>}EAD)

That means OFB+ASS+(anything not OFB or ASS). On other words every BS_TYPE value

[sasiparupudi1]

sum({<BS_TYPE -={'ASS','OFB','XYZ','ABC','XXX','YYY'},%Month = {'$(=$(=vPrevMonth))'}, %Year = {'$(=$(=vPrevYear))'}>}EAD)