OR + AND in SET

[Anonymous]

The attached shows Acct with a product or set of products, but I want to see where it has product MQ or MRO AND THER.  Is it two separate sets?  I cannot seem to get the syntax.  The text box "Acct with MQ or MRO AND THER" shows the expected value.

[MayilVahanan · Accepted solution]

HI

Try with this

=count({<Account__Number=P({<Platform_Product_Line={'MRO','MQ'}>}Account__Number)> * <Account__Number=P({<Platform_Product_Line={'THER'}>}Account__Number)>}DISTINCT Account__Number)

[Anonymous]

Thank you so much!