Skip to Content
author's profile photo Former Member
Former Member

Result Row value Issue

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Jan 10, 2005 at 09:32 PM

    Use the "Calculate Result As..." option in the properties of the Formula and select "Average of All Values <> 0" or "Average of All Values" based on the need to eliminate overlapping formulae.

    Hope that helps.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Rishi,

      I tried as per you're suggestion. It didn't work.

      See my key figure is "No.Of Shipment" & formula is

      "Total no. of Shipment" = SUMCT (No.Of Shipment)

      So whenever the result row of "No.Of Shipment" changes then "Total no. of Shipment" should pick up the value.

      Please let me know if you have any other solution.

      Thanks

      Mahendra

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.