Result Row value Issue

32 Views

Hi All,

I have created a query which has multiple selection & formula in it. One of my formula is not working properly.

Description of the issue:

Key figure is "no. of Shipment"

A calculated key figure "Total no of Shipment" is capturing the result row value of "No of Shipment".

But some time it doesn't work as expected. I don't know why.

For example if I select a week range then it dosen't work. I have used the "Total no of Shipment" in no. of other calculated key figure for calculation.

Meaning for %On-Time = (On-Time A%Total no of Shipment)

Below query is filter by fiscal week =Result

Plant|FiscalWeek|NoofShipments|Totalnoof Shipments|%OnTm

===== ====== ========= ========== ========

A | Result | 98 | 78 | 104.10 %

Here "Total no. of Shipment" should be 98 but is not able to pick up the Result value & it getting 78...I don't know from where it get the number.

Please let me know if any body has faced similar case or is there any OSS note to fix the issue.

Thanks

Mahendra