Expression

[priyarane]

Hi Community,

how to write below expression

bis_entity_type_new in ('SME_EU', 'SME_EU_RET') THEN rwa/0.7619  

[tamilarasu]

Try like 

If(match(bis_entity_type_new,'SME_EU','SME_EU_RET'),rwa/0.7619)

[vishsaggi]

You can also use wildmatch here for case insensitive search.

If(wildmatch(bis_entity_type_new,'*SME_EU*','*SME_EU_RET*'), rwa/0.7619)

V.

[jagan]

HI,

Try this expression

=Sum({<bis_entity_type_new ={'SME_EU', 'SME_EU_RET'}>} rwa) /0.7619

OR

=Sum({<bis_entity_type_new ={'SME_EU', 'SME_EU_RET'}>} rwa/0.7619)

Hope this helps you.

Regards,

Jagan.