Variable in Set Analysis

[#1]

Good morning,

I am trying to do a set analysis calculation, and i'm running into some trouble.

This one seems to work:

count( {$< CustomerSales = {"<=$(#vTier1)"} >}  DISTINCT [WH Customer])

But when i add a second variable in there, to say greater than tier 1 but less than tier 2, it doesn't work.

count( {$< CustomerSales = {">$(#vTier1)"}, CustomerSales = {"<=$(#vTier2)"}>}  DISTINCT [WH Customer])

Not sure why this one doesnt work...

Much thanks,

-David

[#2]

I'm trying to count the distinct customers whose sales are greater than Variable vTier1 but less than Variable vTier2

[Gysbert_Wassenaar · Accepted solution]

Try it like this: count( {$< CustomerSales = {">$(#vTier1)<=$(#vTier2)"}>}  DISTINCT [WH Customer])

[#4]

Great! This works!

Is my method a possible way to do this as well?

[Gysbert_Wassenaar]

Nope. Well, you could do it like this:

count( {$< CustomerSales = {">$(#vTier1)"}> * <CustomerSales = {"<=$(#vTier2)"}>}  DISTINCT [WH Customer])

But it is less clear imho and could perform worse too since first two sets are calculated and then intersected with each other.

[#6]

Much Much appreciated!