When building out your sheets in Adaptive Insights it is critical to keep in mind the sheet’s load time and performance. There are many ways to improve load time of your sheets, one of which is to optimize the DIV and IF functions.

DIV vs DIVF

By adding an ‘F’ at the end of the DIV function, your DIVF function will evaluate faster than the previous DIV function. Both functions have the same syntax:

  • DIV( N, D )
  • DIVF( N, D )

The DIV function is used to help avoid errors that occur when a function divides by 0 with a valid numerator. In a normal N/D formula if the denominator is 0, it will generate an error. With the DIV function, if the denominator is 0, it will return a 0. If the numerator of the function throws an error the DIV function will produce that error as well.

The reason DIVF evaluates faster than its counterpart is because it will evaluate the denominator portion first, and if its value is 0, the function will not continue to evaluate. Even if the numerator throws an error, the DIVF function will return a 0.

The below Formula Pane screenshots illustrate the differences:

N/D Formula

 

 

 

 

  • IF ACCT.SN.SN_Quantity = 0, then, answer = Zero Denominator Error.
  • IF ACCT.SN.SN_ASP = Error1, then, answer = Error1.

DIV Formula

 

 

 

 

  • IF ACCT.SN.SN_Quantity = 0, then, answer = 0.
  • IF ACCT.SN.SN_ASP = Error1, then, answer = Error1.

DIVF Formula

 

 

 

 

  • IF ACCT.SN.SN_Quantity = 0, then, answer = 0.
  • IF ACCT.SN.SN_ASP = Error1, then, answer = 0.

IF vs IFF

Similarly, to the DIV function, by adding an ‘F’ at the end of the IF formula, your IFF formula will evaluate faster than the previous IF formula. Both functions also have the same syntax:

  • IF( x, y )
  • IFF( x, y )

The IFF formula evaluates the ‘x’ condition first and if that condition is met the formula does not evaluate the ‘y’ condition, whereas the IF formula evaluates the entire formula every time ( ‘x’ and ‘y’ conditions).

The below IF formula would be evaluated from top to bottom:

 

 

 

In the below IFF formula, if the Yellow section conditions are met, then the formula produces the Green section and the evaluation ends. The Red section is only evaluated if the Yellow section conditions are not met.

 

 

 

It is good practice to create the initial formulas with the DIV and IF statements to test that both conditions are working correctly.  Once validated, it is recommended to use the DIVF and IFF statements.

A nice side note to help remember the differences; In both cases the additional ‘F’ stands for FAST!