Divide by zero problem in table field

[Shiwani]

Hello,

I have attached an image of table in report. please refer.

As per attachment, In the field of table where column is '%Completion' (C) and row no is  third(in green), i want division of field (No of  Elearning Courses on Curriculum(A) and No of  Elearning  Courses completed(B)) , but when i use (fields.No of  Elearning Courses on Curriculum / fields.No of  Elearning  Courses completed) the report shows divide by zero error.

please help me to come out of this.

[Dave]

You need to check for zero values when dividing. You can use this expression format:

= IIF(Fields.ColumnB>0, Fields.ColumnA/Fields.ColumnB, 0)

[Stef]

Hi,

You can also use the ?: operator, instead of the IIf function as both sides of the function are evaluated during the processing.

Regards,
Stef
Telerik by Progress