Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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)
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)
Thank you so much!