Divide by Zero (Report Items)

Question

Divide by Zero (Report Items)

mbrady5

SSCrazy

Points: 2835
More actions
December 3, 2015 at 7:36 am

#399416

Hello,
could use some help with the Div by 0 error in the following expression. Thanks
=(ReportItems!qty_complete.Value/(ReportItems!qty_complete.Value + ReportItems!qty_scrapped.Value))

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Scott Mildenberger Ten Centuries Points: 1351 More actions · Answer 1

How about this:

=IIf((ReportItems!qty_complete.Value + ReportItems!qty_scrapped.Value) <> 0, (ReportItems!qty_complete.Value/(ReportItems!qty_complete.Value + ReportItems!qty_scrapped.Value)), 0)

mbrady5 SSCrazy Points: 2835 More actions · Answer 2

mbrady5

SSCrazy

Points: 2835

December 3, 2015 at 7:51 am

#1843772

Thanks for trying but, this did not work.

mbrady5 SSCrazy Points: 2835 More actions · Answer 3

I was able to solve this using some simple code from this;

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/e75d0137-d386-4491-9093-78590d2cddf0/division-by-0-error-when-using-reportitems

Thanks