3 Replies Latest reply: Jan 13, 2016 9:29 AM by vishal waghole RSS

    count as condition inside set

    Tomas Hylander

      Hi,

      I'd like to sum up customers that have more than 5 orders and lives in Sweden.

      Tried to search for a solution but couldnt find how to use Count inside a Count.

      This is what i have as of now;

       

      count({$<Country={'SWE'} >} DISTINCT Kundnr)

       

      and I would like to have something like this;

      count({$<Country={'SWE'}, Count(ordernr)>=5 >} DISTINCT Kundnr)

       

      Thanks in advance!