Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is it possible to make a selection based on a function or a calculation in a variable?
lite: < avg(salesid) ?
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?
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?
Yes that was exactly what i wanted thank you