Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
I love you 😃
Thank you very much.