Forum Discussion

rebrow31's avatar
rebrow31
Icon for Helper I rankHelper I
4 years ago
Solved

Dividing a sum number by different values

Hi,    I have the below summarised data in a graoh:      The graph shows how many parts were produced on each machine.  For the parts that are produced, they are packed in to stillages. D...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi rebrow31 ,

     

    You may refer to my sample to learn more details. I hope it could help you solve your problem.

    Parts:

    Stillages:

    Create an relationshio by Machine columns.

    Measure:

    Stillage can be created by each machine = 
QUOTIENT(SUM(Parts[Parts]),SUM(Stillages[Amount]))
    Remaining parts = SUM(Parts[Parts]) - SUM(Stillages[Amount])*[Stillage can be created by each machine]

    Result is as below.

     

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi rebrow31 ,

 

You may refer to my sample to learn more details. I hope it could help you solve your problem.

Parts:

Stillages:

Create an relationshio by Machine columns.

Measure:

Stillage can be created by each machine = 
QUOTIENT(SUM(Parts[Parts]),SUM(Stillages[Amount]))
Remaining parts = SUM(Parts[Parts]) - SUM(Stillages[Amount])*[Stillage can be created by each machine]

Result is as below.

 

Best Regards,
Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

rebrow31's avatar
rebrow31
Icon for Helper I rankHelper I
4 years ago

This worked perfectly, thank you so much for your help!