sql server reporting services: i'm trying to calculate a percent field with the following expression and
getting the error message above:

=IIF(Fields!valorPrevisto.Value = 0, 0, Fields!valorRealizado.Value /
Fields!valorPrevisto.Value)

what am i doing wrong ?

Hi levogiro -

Check out this thread. It describes the problem and offers a couple of
solutions.

http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/481dcece9e84c707/d34656d64a7f39a9?q=divide+by+zero+expression&rnum=4&hl=en#d34656d64a7f39a9
HTH...

--
Joe Webb
SQL Server MVP


~~~
Get up to speed quickly with SQLNS
http://www.amazon.com/exec/obidos/tg/detail/-/0972688811

I support PASS, the Professional Association for SQL Server.
(www.sqlpass.org)




On Tue, 13 Sep 2005 07:08:05 -0700, "levogiro"
[quoted text, click to view]