Expressions - right formula

[#1]

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.

[Miguel_Angel_Baeyens · Accepted solution]

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

[#3]

I love you 😃

Thank you very much.