Get Empowered: Empower User Question | Tip #210 Custom Field Values
Tip #210: Empower User Question: Reporting Custom Field Values in Empower
In this week’s tip, we will answer another Empower user question regarding Custom Field values.
Q: 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?
Great question. Let’s get started.
Custom Field 1 is a simple Intersample Peak Field calculating the average area for the peaks using all injections (figure 1).
Custom Field 2 is a Simple Peak Field which takes the average area, minus the area for an individual peak, divided by the average area, times 100 (figure 2).
Custom Field 3 is a simple Intersample Peak Field calculating the average value for Custom Field 2 (figure 3).
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 (figure 4).
The solution is to include the full calculation for Custom Field 2 in Custom Field 3 (figure 5).
Now the average value reported is the same for all injections and the proper values are reported (figure 6).
It’s that easy!
Final Note: You can use either the Pro or QuickStart interface for this tip.
Please rate this Empower Tip of the Week
Next week in Empower Tip #211 – We will revisit our VLOG series showcasing Empower as an important tool to implement Method Lifecycle Management (MLCM) and discuss the MVM option in Empower.
JOIN US for an Empower: Ask Me Anything Webinar on March 17, 2021
Neil will answer your questions about Reporting.
More Empower Resources:
- Get the latest Empower projects, options, and more. Check out the New Waters Marketplace.
- Want to learn more? Check out our Empower training courses and eLearning.
- Minimize your lab downtime and protect your business against potentially expensive disruptions with the Empower Enterprise Software Extended Critical Support Plan with 24 x 7 x 365 coverage – Learn more
- Build your technical skills and professional network. Share, ask, and interact with peers from around the globe in dynamic discussions by joining our Informatics Community Forum.
Do you want Empower Tips sent to your inbox every week?
Questions? Tips of your own? Let us know!