Truncating Numbers in Custom Fields in Empower - Tip229

Last updated
Save as PDF
Share
1. Share
2. Tweet
3. Share

Article number: 201067

OBJECTIVE or GOAL

How to truncate numbers in a Custom Field

Empower Tip of the week #229

ENVIRONMENT

Empower

PROCEDURE

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

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

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

STEP 4
The result is a truncated value of the USP signal to noise ratio (s/n) (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.

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

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

It’s that easy!

ADDITIONAL INFORMATION

Final Note: You can use either the Pro or QuickStart interface for this tip.