Using the Round Function in Custom Fields in Empower - Tip227

OBJECTIVE or GOAL

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.

ENVIRONMENT

• Empower

PROCEDURE

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

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

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

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

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

It’s that easy!

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

ADDITIONAL INFORMATION