Filter Where KF Results Row Equal Zero

[Former Member]

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.

[Former Member]

Used Data functions SUMCT AND SUMGT

[Former Member]

Ok. I suggests you the following

for eg if A, B and C is the KF's used for 'total amount' calculation.

then please calculate that total amount in the infoprovider level itself and give it as an infoobject.

that infoobject you can use in declaring an exception in you BW qeury .

Regards:)

[Former Member]

That sounds really interesting. How do I do the total at infoobject level? Any help is much appreciated.

[Former Member]

Add a new IO at infoprovider -

---

> use a fomula (abc) for the new infoobject. You can use the exception for this new infoobject.

Cheers

Chanda

[Former Member]

instead of creating a KF in the infoprovider, you can create a CKF\Local Formula in the query designer and then create an exception on that

- Godhuli