Skip to Content
0
Former Member
Mar 16, 2009 at 04:17 PM

Wrong figure displayed in overall Result

34 Views

Hi,

I have a report output for each material with the following:

For each row;

Depot 1

Order Qty (a) | Delivery Qty (b) | Service Level % (b/a * 100)

9 0 0

Depot 2

Order Qty (a) | Delivery Qty (b) | Service Level % (b/a * 100)

17 16 94.12

Depot 3

Order Qty (a) | Delivery Qty (b) | Service Level % (b/a * 100)

9 3 33

Overall Result

Order Qty (a) | Delivery Qty (b) | Service Level % (b/a * 100)

35 19 42.48

My issue is that the overall result displays (094.1233) / 3 i.e. 42.48 instead of

19 / 35 i.e. 54.29

How can I get it to display the correct figure? I am in BI7

Thanks,

Milind