Do you want Empower Tips sent to your inbox each week?
  • Support Articles

Empower Tip: Custom Fields

Empower Tip: Custom Fields

Tip #229: Truncating Numbers in Custom Fields in Empower

Tip #229: Truncating Numbers in Custom Fields in Empower

In this 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.

STEP 1

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.

STEP 2

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.

STEP 3

STEP 3

Create a Custom Peak field, ‘Data Type Real’.

STEP 4

STEP 4

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

STEP 5

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

STEP 6

Create another Custom Peak field, ‘Data Type Real’.

STEP 7

STEP 7

The result is a truncated value of the Peak Area.

It’s that easy!

Final Notes

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


About the Author

About the Author
Neil Lander

Neil Lander

Neil provides internal support for Empower CDS software and is focused on developing laboratory software solutions that help organizations achieve their scientific and operational objectives.



¿Necesita ayuda? Contactar con un experto de Waters. 

Volver arriba Volver arriba