Tip #227: Using the Round Function 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 answered an Empower user question and learned how to determine which Results have been Signed Off using a View Filter. (Tip #226).

In this week’s tip, we will learn how to use the Round function in Custom Fields.

The Round function is very useful in cases where you want to make the comparison of numerical results easier or comparing numerical results from other data systems to Empower.

Let’s get started.

Step 1

The Round function allows you to round large numbers in calculations. As with all formulae in Custom Fields, there is a syntax that must be followed. Here is the syntax and some examples of how rounding works (figure 1).

Figure 1

Step 2

In the first example, I’ve created a simple Peak Custom Field to round the ‘USP Plate Count’ to make it easier to compare and/or trend results (figure 2).

Figure 2

Step 3

You see the rounded values are easier to compare since in this method, ‘USP Plate Count’ values are quite different from peak to peak (figure 3).

Figure 3

Step 4

In the second example, I’ve created a simple Peak Custom Field to round the ‘USP Tailing’ (figure 4).

Figure 4

Step 5

You see the rounded values, and in this case, all the peaks are very symmetrical in shape (figure 5).

Figure 5

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 #228: We will revisit our VLOG series showcasing Empower as an important tool to implement Method Lifecycle Management (MLCM) and discuss Peak Purity Analysis with PDA and QDa detectors.

JOIN US for a webinar on June 17, 2021

Accelerate Your Method Development and Validation with Empower Chromatography System

Learn More and Register

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.