/ Help centre
← All articles
End Users › General

I'm adding a calculated column in a Dashboard but it is not returning any results.

Applicable Versions: All Most likely cause is a possible division by zero in the calculated column. If this happens in a single row, it prevents the entire calculation. You can use the IIF expression to handle this, i.e IIF( [MyColumn1] <> 0 , [MyColumn2] / [MyColumn1] , 0 ).

Updated 11 April 2018

Applicable Versions: All


Most likely cause is a possible division by zero in the calculated column.


If this happens in a single row, it prevents the entire calculation. You can use the IIF expression to handle this, i.e  


IIF( [MyColumn1] <> 0 , [MyColumn2] / [MyColumn1] , 0 ).

Need a hand?

We’re here if you need a little more help.

Contact support ↗