Combination of set and IF statements

[#1]

Hi All,

Can we write set analysis and if combination like below.

will it work,I am seeing error in this expression.

Sum({<[Interior or Box or Front]={'Box'}>} if(count(TOTAL <[PO Item Set], [Sales Order]> [Sales Order])=1,[Ordered Qty]))

Will it work??,please provide your valuable suggestions.

Thanks

[#2 · Accepted solution]

Hi,

Try this.

if(count(TOTAL <[PO Item Set], [Sales Order]> [Sales Order])=1, Sum({<[Interior or Box or Front]={'Box'}>} [Ordered Qty]))

Hope it will help.

[#3]

Thanku ,looks perfect