Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I know how to do set analysis with text, but with numerical values, I'm not sure. I have a condition where I need to exclude all $0 values from my calculation. Here is my syntax so far:
[Gross Sales Order US Dollar Amount]-=0
How do I select where values are not equal to zero?
[Gross Sales Order US Dollar Amount ] = -0
Note the position of the "-", to the right of "=".
-Rob
I don't see a change when I move the "-" sign to the right of "="
What about less than 0 or greater than zero?
Shouldn´t it be
[Gross Sales Order US Dollar Amount]-={0}
?
Regards, Thomas
Or you use the if function instead of set analysis ...
Can you post the expression you are using?
-Rob
-= and =- are two different things in Set analysis.
-=0 means "remove 0 from the current selections".
=- means "select not 0".
-Rob
in this case i will use the if function
if [Gross Sales Order US Dollar Amount] <> 0, Parameter
You can use any of your dimensions for the parameter
Use <[Gross Sales Order US Dollar Amount] -= {0}> if it's numerical value or
If it's a string use <[Gross Sales Order US Dollar Amount] -= {'$0'}> in your set analysis expression.