Skip to Content
0
Former Member
May 08, 2013 at 05:06 AM

Query with conditions

30 Views

HI Everyone,

I have a BEx query for sales order data in the following format:

Sales Doc No. Req. Qty Del Qty Calc

The column of Calc does some calculation based on remaining two KPI's.

The query has a condition to show Req. Qty values greater than 0.

The result row of Calc does an average of values, but this calculated figure also includes Req. Qty values which are 0 which gives a wrong picture.

This is probably happening because the values are there in the query output, but are just getting hidden by the condition.

Is there a way we can avoid such that the Calc result does not include the values being excluded by the condition?

Please help.

Regards,

Bhushan