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

New Formula in the query designer

Posted on Dec 10, 2004 at 06:11 PM 15 Views

Hello Gurus,

How do i define a formula taking characteristic and key figure values. I tried to do a selection of both but the problem is its just taking the key figure value and not the characteristic. I am new to this so please if someone could explain it would be a great help. Example have 'Production' as the key figure value, 'Part run count' as the characteristic value. I want to define a formula for 'Part run per metric ton' which is part run count/production/1000. I defined Part run count as a selection including production and part run count but when i defined the formula, the result just takes the production values and not the part run count. Hope my explanation is clear.

Thanks in advance,

Anjali

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Dec 10, 2004 at 08:15 PM
    0

    Hi Anjali,

    If I understand correctly you should try a formula variable. Using that you can use a char value in a formula.

    Let me know if you need more info,

    Michael

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member
      Dec 13, 2004 at 02:34 PM

      Hello Dirk,

      Its not about the visibility in the query about the 'Selection' but when i am trying to define a formula using a selection (which has both key figure and characteristic) and a key figure, the formula takes only the key figure in the selection but doesn't involve the characteristic. So i would like to know how to define a formula using a selection which involved both key figure and characteristic.

      Thanks,

      Anjali

    Comment on This Answer

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.