Just like in Excel, you need functions in Empower to perform calculations and assessments inside your Custom Fields. Let’s have a look at some of the most common ones used in calculations:

AVE — average

SUM — sum of values

%RSD — relative standard deviation

MAX, MIN — maximum and minimum value

ABS — absolute value (removes minus)

A couple of simple examples:

To show the maximum Peak Area per result:

Field Type: Result
Data Type: Real
Formula: MAX(Area)

To calculate % of total amount:

Field Type: Peak
Data Type: Real
Formula: Amount/SUM(Amount)*100