Just looking at the jpg it looks like whatever formula you're using for Diff in Proj Class # is producing 20 nulls. If you want a quick and easy way to filter these out put a ZN() around your whole statement, which will convert your nulls to zeros and allow you to then use the <> to zero filter you tried before.
There are many other ways of dealing with nulls, but you'll need to post a packaged workbook (twbx) if you want us to take a look at your workbooks.
PS: OK, I'm lazy, yes we could have messed around putting the workbook together, but it's best to get everyone trained to post packaged workbooks .
Thanks Shawn - had a look at the auto Table Calc - and it already had ZN - so I don't think the prob was NULL vs zero.
Did have some success however with the' ABS Difference From' calc:
ABS(ZN(SUM([Project Classification #])) - LOOKUP(ZN(SUM([Project Classification #])), -1))
And then by filtering this calc 'at least 1' gets rid of the projects with 0 difference. (I was almost there before - but didn't have compute using Table Across in the filter)
My last problem that someone may have a tip for me on - is now that I've filtered out the 'zero difference' projects, the sum(project classification #) column wont let me use project classification as a label or colour without the measure disappearing.
Will try to attach jpg and for the lazy (but helpful) folks out there - a twbx!!! - don't have a attach button in the reply window?
aha - got it now
i'd already workedaround by attaching files back at the first thread
Awesome - thanks for the tip.