How to create a Not Equal to Zero condition in Set Analysis?

[john_henry]

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?

[rwunderlich]

[Gross Sales Order US Dollar Amount ] = -0

Note the position of the "-", to the right of "=".

-Rob

[john_henry]

I don't see a change when I move the "-" sign to the right of "="

[john_henry]

What about less than 0 or greater than zero?

[thkarner]

Shouldn´t it be

[Gross Sales Order US Dollar Amount]-={0}

?

Regards, Thomas

[#6]

Or you use the if function instead of set analysis ...

[rwunderlich]

Can you post the expression you are using?

-Rob

[rwunderlich]

-=  and =- are two different things in Set analysis.

-=0 means "remove 0 from the current selections".

=- means "select not 0".

-Rob

[Anonymous]

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

[afsarshaikh]

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.