Issue in set analysis

[#1]

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

[Gysbert_Wassenaar]

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])

[#3 · Accepted solution]

Sorry, it should ahve been match not equal to