2 Replies Latest reply on Oct 18, 2016 7:47 AM by Kate Kennedy

# Calculation for Difference btwn Two Measure Values

Hello,

I'm sure this general topic comes up quite often, but I'm having trouble finding a solution in the existing documentation/forum discussions.

I work at a manufacturing plant, and one of the processes we have is to dry and sift powder to become different chemical compounds. The powder is dried in one machine and sifted to uniform size at another - and there will always be some amount of loss at each of these machines. I have data related to the weight of the powder at the Drying machine and the weight of the powder at the Screening machine - each machine is listed as a value in the "Location" dimension. I need to calculate the difference in weight of the powder when it comes out of the dryer and when it comes out of the screener.

So, I have a weight value (quantity) for each tote of powder (serial number) at both locations. How can I create a calculation to solve this? I've attached my workbook for context.

Many many thanks!

• ###### 1. Re: Calculation for Difference btwn Two Measure Values

Hi Kate,

I can't open your workbook because it is using a live connection.

However, by reading your description, it seems like you can break apart the location dimension like so:

Calc 1: IF [Location] = 'Screeening' then [Weight] END

Calc 2: IF [Location] = 'Drying' then [Weight] END

Then take difference of the 2 calcs.

Hope this helps!