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

# Expressions - right formula

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.

• ###### Re: Expressions - right formula

Hi,

Yes, if the values are numeric this should work:

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

That will use the set formed by values A-D in Klasa artikla and values not between 000 and 499.

Hope that helps.

Miguel

• ###### Re: Expressions - right formula

I love you =)

Thank you very much.