CUSTOMER ZONE

Error: (#DIV/0!) displays in a custom column’s cell of a report?

Find resources designed to help you get the most from Replicon

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))

Start a free Replicon trial today based on your business needs

Start Free Trial