Not include in Output if $0

[Jmaldonado]

Hi,

I was working joining three inputs if the restaurant # repeats in all of three inputs. Now, I'm trying to exclude a Restaurant from the output if the variance amount is $0 for all three inputs. In other words, MI 1554 shouldn't be on the list as is $0 for all the three variances. 

Attached the workflow I have so far along with the three inputs. 

Thanks in Advance!

[Luke_C]

Hi @Jmaldonado 

You should be able to add another filter that checks this, see below example. You could check if each variance = 0

[Variance Input 1]!= 0 or
[Variance Input 2]!= 0 or
[Variance Input 3]!= 0

[RaviP]

Hi @Jmaldonado ,

You could find out column total using the crosstab and exclude the records where the Total is 0

Ravi

[Luke_C]

@RaviP Awesome alternative! One word of caution with this approach is that it would be possible for the fields to net across to 0 (i.e. 50 and -50). Checking if the sum of each fields absolute values would be safer.

[RaviP]

True that @Luke_C .

I wanted to use the union tool and exclude the 0 Variance and null variance, but then I would've needed another column to identify the 3 different variances. I did not want to use 3 different formula objects to add another column.