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

Formula Help needed


material Produced qty Consumed qty %consumption

-


A11 4 2 2/15

B11 5 3 3/15

C11 6 4 4/15

-


Result 15

-


Hi Experts,

We have a report like this as per our business rule

%consumption = value of individual row in consumed qty/result of produced qty column.

result of produced qty column = SUMCT(produced qty )

We use SUMCT to get the result of produced qty and is used in the formula. The issue here is when we drill down and swap with different characteristics it is not bringing right results.

Any better solution to fix this issue is appreciated.

Thanks,

Varun.

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Mar 23, 2006 at 08:31 PM

    oops, the formatting is not working properly

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Varun,

      instead of using the SUMGT , use cell definitions and use the formula there , u will not have this problem.

      The problem here is , u are writing the formula for that particular KF that is why when u are swapping the characteristics ur formula is not working.

      use define cels and write the formula there.

      Hope this Helps

      regards

      Majeed

  • author's profile photo Former Member
    Former Member
    Posted on Mar 24, 2006 at 02:14 PM

    Hi Majeed,

    Can you elaborate your idea,

    Thanks,

    Varun.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      dear Varun,

      as mentioned by Majeed, to avoid wrong result when navigate (drill down etc), you can use 'constant selection', detail see following

      http://help.sap.com/saphelp_bw33/helpdata/en/e7/5f983c1a356858e10000000a114084/frameset.htm

      ....

      Selecting Constants

      Use

      In the Query Designer, you use selections to determine which data you want to display for the report runtime. You can then alter the selections during runtime using navigation and filters – that is, you can restrict the selections further.

      The function Constant Selection allows you to mark a selection in the Query Designer as constant. This means that navigation and filtering have no effect on the selection for the runtime. In this way, you can easily select reference sizes that you cannot change for the rest of the runtime.

      ...

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.