Get Empowered: Tip #229 | Custom Fields, Truncate Numbers
Tip #229: Truncating Numbers in Custom Fields in Empower
Welcome back to Get Empowered! In the last Empower tip-of-the-week blog for Empower Chromatography Data System, we revisited our VLOG series showcasing Empower as an important tool to implement Method Lifecycle Management (MLCM) and discussed Peak Purity Analysis using both PDA and QDa detectors (Episode #12/Tip #228).
In this week’s tip, we will learn how to truncate numbers in a Custom Field.
In Tip #227, we learned how to round numbers. There may be times when you need to simply truncate or shorten a number without rounding, to accomplish this, we use the Round function in a Custom Field.
Let’s get started.
Figure 1 is a summary of the syntax used for the Custom Fields used to truncate numbers either to the left or the right of the decimal point (figure 1).
In the first example, you want to truncate the USP signal to noise ratio (s/n) to the second number to the right of the decimal point (figure 2).
Create a Custom Peak field, ‘Data Type Real’ (figure 3).
The result is a truncated value of the USP signal to noise ratio (s/n) (figure 4).
In the second example, you want to truncate Peak Area to the second number to the left of the decimal point. Peak Area is a real number, however, Empower defaults to displaying Area as a whole number (figure 5).
Create another Custom Peak field, ‘Data Type Real’ (figure 6).
The result is a truncated value of the Peak Area (figure 7).
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 #230: We will review working with QDa data in Empower.
JOIN US for a webinar on June 17, 2021
Accelerate Your Method Development and Validation with Empower Chromatography System
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!