Skip to Content
0
Former Member
Oct 21, 2009 at 02:10 PM

Filter Where KF Results Row Equal Zero

15 Views

I want to write a query that shows cost centre line item data but I only want to see cost centres where the overall amount comes back tro zero. Anybody any idea how I filter out other cost centres where the overall amount doesnt come back to zero? I cant filter by key figure and I dont understand how I put a condition against the result row for a cost centre as cost centre isnt the only row as I want see spend against all cost centres. Does that make sense? Any help greatly appreciated.