Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Can someone please tell me what is the issue in this set analysis expression.
sum({<[Order Line Item Type Code]={'STANDARD','MODEL'},match([Order Type]={*WARRANTY*,*AFTERMARKET*,*RETURNS*})>}[Unit Price])
Thanks in advance.
Regards,
Adi
Sorry, it should ahve been match not equal to
This is: match([Order Type]={*WARRANTY*,*AFTERMARKET*,*RETURNS*})
You can onky use field names on the left side of the =, not expressions.
Try: sum({<[Order Line Item Type Code]={'STANDARD','MODEL'},[Order Type]={'*WARRANTY'*,'*AFTERMARKET'*,'*RETURNS*'}>}[Unit Price])
Sorry, it should ahve been match not equal to