Conditions for KF Greater than Zero

[Former Member]

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

[anshu_lilhori · Accepted solution]

Hi,

I think this is a normal behavior as at company code level you only have one record so it tend to aggregate the data.That is how OLAP server is meant to work.

At company code level what order value and quantity you are trying to display please let us know.

Regards,

AL

[Former Member · Accepted solution]

Hi Anshu n Suman ,

Thanks for you promp responses .

@Anshu ,

At Comp Code Level , I want to display only Order value , where Quantity is Greater than Zero .

@Suman ,

Yes you are correct . But the Users dont want to see the Documents in the Reports

Thanks and Regards

Vigneshram Selvaraj 

[anshu_lilhori · Accepted solution]

Hi,

A nice workaround which i can think in your case is.

Make a new formula and write a condition inside it like this:

(ordqty==0)*0+(ordqty>0)*ordvalue

Now finally use this order value in your report.

Hope that helps.

Regards,

AL