This discussion is archived
3 Replies Latest reply: Dec 3, 2012 6:02 AM by Srini VEERAVALLI RSS

Suggestion on filter condition

Suman OTN Newbie
Currently Being Moderated
Hi

I have a filter condition as below as it is in filter transformation.

variance!=0 or ISNULL
(variance)

I want to change the code so that it should filter the variance even it has zero

so I modified it as

variance!=0 or variance=0
(variance)

but its throwing an error.

Please suggest what is the correct way. If I remove (variance) from the condition its working fine.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points