Set Analysis multiple conditions

[evansabres]

I need to create an expression that has multiple conditions

I want to sum the 'QTY' of the following BUYER_TYPE_CODES

Tried the following, but it did not work:

=SUM({<[BUYER_TYPE_CODE] = {"ABC*"}, [BUYER_TYPE_CODE] = {'DEF'}, [BUYER_TYPE_CODE] = {'QWE'}, [BUYER_TYPE_CODE] = {'RTY'}, [BUYER_TYPE_CODE] = {'UIO'}, [BUYER_TYPE_CODE] = {'KIF'}, [BUYER_TYPE_CODE] = {'ZZZ'}, [BUYER_TYPE_CODE] = {'OSI'}>} QTY)

[StarinieriG · Accepted solution]

Hi,

try this expression

SUM({<[BUYER_TYPE_CODE] = {'ABC*','DEF','QWE','RTY','UIO','KIF','ZZZ','OSI'}>} QTY)