Home Forums Reporting Services Reporting Services Divide by Zero frustration RE: Divide by Zero frustration
ansuman2006
SSC Eights!
Points: 987
More actions
January 22, 2012 at 1:38 pm
#1436919
My problem was to display zero if the value of the denominator is zero, else the division of the two fields.
So what I used is mentioned below,
iff(Field2=0,0,Field1/Field2)
I worked.. Hope it does the same for you all... 🙂