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

Divide one KFu00B4s line value with another KFu00B4s total value?

I have a problem in my query; I need to divide one key figures line value with another key figures report total value, see example below. For instance I need to divide Material A’s price with the total invoice amount for all materials.

”Material” “Price/Unit” ”InvoiceAmount” “Weighed index”

A..............10..................350.............(10/1000)=0,01

B..............20..................350..............(20/1000)=0,02

C..............30..................300..............(30/1000)=0,03

-


..................................1000

Any suggestions on how to solve this problem? I’m currently using formulas.

Best Regards

/Daniel

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    Posted on Feb 02, 2005 at 09:43 PM

    You can try the following:

    1. Create a new local formula F1 = SUMGT (InvoiceAmount)

    2. Create Weighed index = Price / F1

    3. You can set F1 properties to Hide

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Bhanu Gupta

      Hello,

      Hey guys that was exellent, Its new to me. Thanks

      Where can I see all the functions available.

      How can we use a "If" condition in a formula

      my request is slightly different.

      A B C D= C*B

      Mat Comp type Qty1 qty2 ratio needed

      20001 10001 C 10 18 10/15 ?

      20001 10002 C 20 40 20/15 ?

      20001 20001 M 15 30 15/15 ?

      How to do column C?

      you guys showed how to use SUMGT() and SUMRT()

      Here one material can have several components , In which one of its component would be material itself. The field "type" describes that, so while calulating the field "C" I need to take the value QTy1 for the component and divide it by the qty1 of the material

      basically I wanted to see the percentage of components in a material.

      hope this is clear with you

      thanks for your kind help.

      its slightly complicated na.....

      regards

      Meps

  • author's profile photo Former Member
    Former Member
    Posted on Feb 02, 2005 at 08:04 PM

    '

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Feb 02, 2005 at 09:23 PM

    You can indeed do this using formulaes. There is one special formulae to retreive a total for any column and use this. I don't have a system available for the moment. But it should work.

    Any other problem?

    Tom

    Add a comment
    10|10000 characters needed characters exceeded

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.