Numeric & Mathematical Functions

These custom functions are related to numeric values or mathematical calculations in general.

Delta Percent

For some math and financial calculations, you may want to know the percentage of change from one number to another. This function will return that information for two numbers given.

Delta Percent Formatted

This one is the same as DELTA_PCT( ), but it formats the results with a percent-sign at the end.

Numeric or Not

There is not a function explicitly for determining if the value of a field is numeric or not. This customized function will return 1 if a given value is numeric, 0 if not.