Expression

[upaliwije]

Hi Friends

Pls see what is wrong with the following expression

sum( if(GROUP_CODE = {'MA','MB','MC','MD','ME'} and TYPE='S',[BUDGET]))

[simenkg]

sum({<GROUP_CODE = {'MA','MB','MC','MD','ME'}, TYPE={'S'}>}[BUDGET])

[ashfaq_haseeb]

Try like this

sum({<GROUP_CODE = {'MA','MB','MC','MD','ME'},TYPE={'S'}>}[BUDGET]))

Regards

ASHFAQ

[upaliwije]

Thanks

I want to add an If condition to this expression

[its_anandrjs]

Hi,

With if function

=sum( if(Match(GROUP_CODE,'MA','MB','MC','MD','ME') and TYPE='S',[BUDGET] ))

Or

=sum( if(WildMatch(GROUP_CODE,'MA','MB','MC','MD','ME') and TYPE='S',[BUDGET] ))

Regards

Anand