Cause:
Custom columns are used to calculate multiple queries. These calculations may involve multiple calculations with addition, multiplication, subtraction and division. When zero is encountered during multiplication or division, it results in null error ‘#DIV/0!’

Resolution:
Using the conditions like if, Text to number, number to text will help us resolve this issue. For instance you may use the custom column formula as:

IF(BaseBillableAmount=0,”,TEXTTONUMBER(BaseBillableAmount/TaskBaseEstimatedCost))

Free trial

Hassle-Free Time Tracking Software from Replicon. Start your Free Trial Today!

Get Started