When ever the my expression returns a zero, the column cell read Nan, how can I fix this?

In a report I have an expression in Col A.
colA expression
= sum(colB)/sum(ColC)
This works.

However, wherever there is a zero after the expression runs,  colA returns Nan.

What is the best way to eliminate this problem?
rhservanAsked:
Who is Participating?
 
derekkrommConnect With a Mentor Commented:
try this:

Iif(ISNOTHING(sum(colB)/sum(colC), 0, sum(colB)/sum(colC))
0
 
CPA_MCSECommented:
THE ACCEPTED SOLUTION IS WRONG.

THE CORRECT SOLUTION IS:

Iif(ISNOTHING(sum(colB)), 0, sum(colB)/sum(colC))

If colB is blank or not there, it will return a 0 instead.
0
All Courses

From novice to tech pro — start learning today.