Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I want to exclude values from a bookmarked set for analysis...
Here's a simple version of my bookmarked set (Set1):
-------------------------------
item CPM
tee-shirt $2.40
tee-shirt $2.45
pencil $0.30
umbrella $10.30
-------------------------------
I have an input box that will allow a user to enter a minimum value for analysys. I've assigned the variable "Set1_MinCPM" to that user entered value.
---------------------------------------------------------------------------------
Let's say for this example that user entered value is: $2.40
so
Set1_MinCPM = $2.40
---------------------------------------------------------------------------------
Now I want to count the number of instances where the cost is >= to $2.40... I'm having problems figuring it out.
This is what I've struggled through so far:
=Count({Set1<CPM={Set1_MinCPM>}CPM)
(count the number of times that the CPM = $2.40) This gives me 0, but it should give me 1
=Count({Set1<CPM={>Set1_MinCPM>}CPM)
(this is just an bad expression)
Any help would be appreciated.
So this is working:
=Count({Set1<CPM-={">=3.50"}>}CPM)
but if I substitute a variable for 3.50 I it does not work.
=Count({Set1<CPM-={">=Set1_MinCPM"}>}CPM)
any advice?
figured it out::
=Count({Set1<CPM-={"<=$(Set1_MinCPM)">}CPM)