Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
Hi,
try this expression
SUM({<[BUYER_TYPE_CODE] = {'ABC*','DEF','QWE','RTY','UIO','KIF','ZZZ','OSI'}>} QTY)
Hi,
try this expression
SUM({<[BUYER_TYPE_CODE] = {'ABC*','DEF','QWE','RTY','UIO','KIF','ZZZ','OSI'}>} QTY)