Get Empowered: Tip #229 | Custom Fields, Truncate Numbers

By June 9, 2021


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.

Step 1

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).

empower

Figure 1

Step 2

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).

Empower

Figure 2

Step 3

Create a Custom Peak field, ‘Data Type Real’ (figure 3).

Empower

Figure 3

Step 4

The result is a truncated value of the USP signal to noise ratio (s/n) (figure 4).

Empower

Figure 4

Step 5

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).

Empower

Figure 5

Step 6

Create another Custom Peak field, ‘Data Type Real’ (figure 6).

Empower

Figure 6

Step 7

The result is a truncated value of the Peak Area (figure 7).

Empower

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

empower


Next week in Empower Tip #230: We will review working with QDa data in Empower.

empower

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:

 

 

Do you want Empower Tips sent to your inbox every week?

Subscribe Now

Questions? Tips of your own? Let us know!

 


Categories: Empower Tips