Jump to content

Calculation of delta from two different measurements


Recommended Posts

Reached out to support last week, awaiting reply but I actually need to figure out this to add to a report today. Does anyone know how to build this formula? The simple approach seen below does not provide needed results. Appreciate any assist. 

image.thumb.png.d6e80a9353934dbe9d1a5f4b074dea93.png

Please sign in to view this quote.

Here's an example of how it is handled. 

You are close, you just need to tell it which piece of information from Variable A and Variable B you want for the actual expression formula. As you can see for the Actual expression, change your formula to:

B.actual_value - A.actual_value

For the Nominal expression, either enter it manually or use the following formula:

B.nominal_value - A.nominal_value

Also make sure to set your unit the specific type of measurement you are working with. 

image.thumb.png.a172e8f13b7e045747ed270f36b2de9f.png

Thanks all for the replies, support also got back with me, got it worked out. Of note for anyone else utilizing: It was also failing on my end to because I was attempting to pull from "Dimensions", instead of "Dimensions (scalar). 

Appreciate the group and support!

×
×
  • Create New...