Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.
Thanku ,looks perfect