2 Replies Latest reply: Oct 10, 2012 7:49 AM by Kristian König RSS

    Expressions - right formula

    Kristian König

      Hello again,

       

      this is my "formula":

       

      Count(DISTINCT{<[Klasa artikla]={A}>} {<[Klasa artikla]={B}>} {<[Klasa artikla]={C}>} {<[Klasa artikla]={D}>} {<[Predgrupa artikla]={000}>}if(WildMatch(COMMISSSALESGROUP,KOM), ITEMID))

       

      The marked is a series of numbers 000 - 999. Is there a possibility, to include in this formula a range?

       

      1. Look at all "Predgrupa artikla" between 000 and 499

      2. Exclude all "Predgrupa artikla" between 000 and 499

       

      Thank you all for your help.