The demo will demonstrate a very common situation: A cross table that includes a custom calculation where a division-by-zero situation can occur.

Labels can be added to the formula to enhance the readability.

  • Create a new Analysis with a Cross table showing Revenue and Costs per Customer
  • Add a new calculation Contribution Margin = (Revenue – Costs) / Revenue * 100.
  • Apply the global criterion Customer Country(Territory) = Asia.


Notice the “Math errors” – which are caused by division by zero.

To fix this, we will implement an “if-then-else” statement in our calculations syntax.

  • In the formula, include an if-then-else statement to handle the division-by-zero issue. Insert “0” when a division by zero is attempted:


Was this article helpful?
0 out of 0 found this helpful



Please sign in to leave a comment.