how to replace NaN to 0 in paginated report

[Anonymous]

Hi Team,

i have made the expression the two columns in divide example is below 

=Sum(Fields!SLA_NOT_MET_6_9_HRS.Value)/Sum(Fields!SLA_NOT_MET_COUNT.Value)

Ater added above expression getting right values but some fields are showing "NaN" Error see below 

Now i want replace the 0 (Zero) instead of NaN. please share your suggestions.

[Rupak_bi · Accepted solution]

Hi,

You may try this
iferror(divide(Sum(Fields!SLA_NOT_MET_6_9_HRS.Value),Sum(Fields!SLA_NOT_MET_COUNT.Value),0),0)