FAQ: What is the difference between Div, Divf, and the / symbol?
All 3 are division operators.
N/D works, but we don’t recommend using it. It is more likely to return errors when N or D are complex calculations, or when they equal 0. It also can burden the performance of the model.
Div (N, D) prevents formula errors. With Div, 0 denominators result in a 0 value instead of an error. As a result you can save your work and populate values into D at a later time.
Divf (N, D) improves performance because it doesn't evaluate the denominator when the numerator is 0. With Divf, 0 numerators result in 0 values. You can save your work and populate the values for N at a later time.
We recommend the following protocol:
- Test formulas with Div.
- Confirm that the formula evaluates as expected.
- Replace Div with Divf to improve performance.