Dashpivot includes built-in operator functions (HF functions) that allow you to perform calculations and logical comparisons inside Default Tables and Prefilled Tables.
These are commonly used for:
Arithmetic operations
Value comparisons
Logical testing
Building conditional formulas
Arithmetic operators
HF.ADD()
Purpose: Adds two numbers.
Formula to use:
=HF.ADD(A1,B1)
Example:
If A1 = 10
and B1 = 5
=HF.ADD(A1,B1) returns 15
HF.MINUS()
Purpose: Subtracts one number from another.
Formula to use:
=HF.MINUS(A1,B1)
Example:
If A1 = 10
and B1 = 5
=HF.MINUS(A1,B1) returns 5
HF.MULTIPLY()
Purpose: Multiplies two numbers.
Formula to use:
=HF.MULTIPLY(A1,B1)
Example:
If A1 = 10
and B1 = 5
=HF.MULTIPLY(A1,B1) returns 50
HF.DIVIDE()
Purpose: Divides one number by another.
Formula to use:
=HF.DIVIDE(A1,B1)
Example:
If A1 = 10
and B1 = 5
=HF.DIVIDE(A1,B1) returns 2
HF.POW()
Purpose: Raises a number to a specified power.
Formula to use:
=HF.POW(A1,2)
Example:
If A1 = 4
=HF.POW(A1,2) returns 16
Note:
The power must be written directly in the formula and cannot reference another cell.
Comparison operators
HF.EQ()
Purpose: Returns TRUE if two values are equal.
Formula to use:
=HF.EQ(A1,B1)
Example:
If A1 = 100
and B1 = 100
=HF.EQ(A1,B1) returns TRUE
Notes:
Not case-sensitive for text values
Returns TRUE if both cells are blank
HF.NE()
Purpose: Returns TRUE if two values are not equal.
Formula to use:
=HF.NE(A1,B1)
Example:
If A1 = 100
and B1 = 50
=HF.NE(A1,B1) returns TRUE
HF.LT()
Purpose: Returns TRUE if Value1 is less than Value2.
Formula to use:
=HF.LT(A1,B1)
Example:
If A1 = 5
and B1 = 10
=HF.LT(A1,B1) returns TRUE
HF.LTE()
Purpose: Returns TRUE if Value1 is less than or equal to Value2.
Formula to use:
=HF.LTE(A1,B1)
Example:
If A1 = 10
and B1 = 10
=HF.LTE(A1,B1) returns TRUE
HF.GTE()
Purpose: Returns TRUE if Value1 is greater than or equal to Value2.
Formula to use:
=HF.GTE(A1,B1)
Example:
If A1 = 15
and B1 = 10
=HF.GTE(A1,B1) returns TRUE
Using operator formulas in Dashpivot helps automate calculations, validate inputs, and support conditional logic within your workflows.