Search string with variables/functions

[#1]

Is it possible to make a selection based on a function or a calculation in a variable?

lite: < avg(salesid) ?

[Miguel_Angel_Baeyens · Accepted solution]

It is possible,

You can create a new variable in the Settings menu, Variable Overview, add a new one, say, vTotalCustNo

=COUNT(DISTINCT CUSTOMER_ID)

And then get it

$(vTotalCustNo)

Is that what you mean?

[#3]

Yes that was exactly what i wanted thank you