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

[Former Member]

Hi All ,

Thanks a lot for looking into this . Each and everyone's answer , has let me know about the Limitation of Conditions .

@AL

Glad to say that your solution works . But with slight modifications . When we remove Document Number from Drill Down , it was causing issue , hence had to do Exceptional Aggregation of type Summation with Reference to Sales Document and Item on each KF .

@Ganesh n Suman ,

Users are not accepting for Multiple Conditions . Also Sale order is not allowed to be a part of Drill Down , it is optional not mandatory .

Thanks and Regards

Vigneshram Selvaraj

[anshu_lilhori]

I am also glad that my solution helped you in resolving your issue with some workaround from your end.

Great!

Regards,

AL

[former_member183012]

Hi,

I think your document should be present in report then only your condition work.Because written condition in such way that Qty = 0.If your report does not have document then qty will 4 that will not fullfill condition correct?

Regards,

Ganesh Bothe

[former_member182470]

I hope you made your condition with "Char Assignment as Document". In that case, your condition will only be applicable when you use Document either in drill down or in Rows pane. So this is standard behavior.

[former_member182470]

Can't they toggle Condition on the report? Keep Document in drilldown, so they will get all records in the first layout. Ask them to drilldown by document and apply Condition on the KF. There is a toggling option.