I have a shapefile with numerous columns that I need to calculate a mean for on a row by row basis. Within the data there are a lot of values equal to 0 that are skewing the mean - how can I set up a calculation in the ExpressionEvaluator to remove the 0's from my calculation?
Solved
How can I set up a calculation to ignore values equal to 0 when calculating the mean?
+2- Contributor
Best answer by dustin
Nulls would not be evaluated in that situation, so I would use a NullAttributeMapper prior to the ExpressionEvalutor setting all 0's to <null>. Then after your ExpressionEvaluator, use another NullAttributeMapper to set <null> back to 0's.
+30- Influencer
- Best Answer
Nulls would not be evaluated in that situation, so I would use a NullAttributeMapper prior to the ExpressionEvalutor setting all 0's to <null>. Then after your ExpressionEvaluator, use another NullAttributeMapper to set <null> back to 0's.
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.