Expression format

[#1]

Hi Community,

I have requirement like below.

1. Label name

if BS_TYPE is not equal to 'ASS' or 'OFB' then name should display like 'EAD expsoure'

2. Exposure

if BS_TYPE is not equal to 'ASS' or 'OFB' then sum of EAD where BS_TYPE = 'ASS' and 'OFB' should not be included.

Please let me know the expression

[jonathandienst]

Is this in a text box, or a chart, or a label somewhere?  What should 'name' display when the condition is not met? What field contains the metric and how do you want that to aggregate?

[Anonymous]

1) if (not ((BS_TYPE='ASS') or (BS_TYPE='OFB')), 'EAD exposure',BS_TYPE)

2) sum({<BSTYPE-={'ASS','OFB'}>}EAD)  -> will always sum without ASS and OFB
   or  ( if (not ((BS_TYPE='ASS') or (BS_TYPE='OFB')), sum(EAD),else) will oly sum if not ASS or OFB

[#4]

Its a Pivot table