7 Replies Latest reply: May 2, 2017 5:52 AM by naveen kumar RSS

    how to write expression

    naveen kumar

      Hello,

                  i have a field called GROUP, and i want to see whether is there any customer who have bought  a product in all the three groups.                                            

       

      =count({<Group={'LIFESPACE','CLUB','FINANCE'}>}Customerid)

       

      but this expression counting all the customer who are in the GROUP irrespective of whether customer bought a product in all the GROUP

      how to write a expression which check and count only those customerid who bought a product at least once in all the three diff GROUP

       

      Thanks

      Naveen