Set Analysis multiple conditions

evansabres — Thu, 12 Sep 2019 14:42:37 GMT

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)

Re: Set Analysis multiple conditions

StarinieriG — Thu, 12 Sep 2019 14:54:00 GMT

Hi,

try this expression

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

topic Re: Set Analysis multiple conditions in App Development

Set Analysis multiple conditions

Re: Set Analysis multiple conditions