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.