Empower Tip: Empower User Question

In this tip, we will answer another Empower user question regarding Custom Field values.

QUESTIOM:

I have an Intersample Peak Custom Field with a summary function which works as expected. The result of that Custom Field is then used in a second Peak Custom Field which works as expected. The result of the second Custom Field is then used in a third Intersample Peak Custom Field with a summary function. The result of that Custom Field increments until the last injection. At the last injection the proper value is reported. How can I get Empower to report the final value without reporting incremental values?

Custom Field 1 is a simple Intersample Peak Field calculating the average area for the peaks using all injections.

Custom Field 2 is a Simple Peak Field that takes the average area, minus the area for an individual peak, divided by the average area, times 100.

Custom Field 3 is a simple Intersample Peak Field calculating the average value for Custom Field 2.

Custom Fields 1 and 2 are calculated properly. Custom Field 3 increments, meaning the average for injection 1 of peak 1 is simply the value of Custom Field 2. The average for injection 2 of peak 1 is the average value of Custom Field 2 for the first 2 injections. Finally, the average for injection 3 of peak 1 is the true average value for all 3 injections.

The solution is to include the full calculation for Custom Field 2 in Custom Field 3.

Now the average value reported is the same for all injections and the proper values are reported.

It’s that easy!