Skip to Content
0
Former Member
Nov 19, 2013 at 04:35 AM

Conditions for KF Greater than Zero

49 Views

Hi Experts ,

I have a requirement to disply the Documents where a particular Order Quantity KF value is greater than Zero . So I created a Formula on the KF , with Exceptional Aggregation on the Order Quantity , of type Summation , Reference Char Document . Then I used this Formula in Conditions , set to Greater than Zero .

Now when the Order Quantity is less than or equal to Zero , I want that particular Document to not show up in the Report . When I remove the Document out of the Drilldown , all the Documents Order Quantity under a Company Code get summed upto greater than zero and hence report geting messed up .

Company Code Document Order Qty Document Count Order Value 1200 100 0 0 100 1200 200 4 1 200

In the above all works good , till we have Document in drilldown , 1st record is not shown in report . But when Drilldown to Company Code , value shows up as 300 . Please let me know if there is a solution , it is pretty urgent .

Thanks and Regards

Vigneshram Selvaraj