Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Reporting Services Div# 0

36 views
Skip to first unread message

cas

unread,
Feb 4, 2008, 5:49:16 PM2/4/08
to
Hola,
SQL Server 2005. Reporting Sevices.
Como se puede evitar el #Error cuando existe una division por cero.
La expresion que utlizo es IIF(field!Total=0,0, Profit/Total*100), la cual
me da el error

jose.d...@singularpm.es

unread,
Jun 14, 2017, 5:51:56 AM6/14/17
to
=IIF(Fields!Numerador.Value <> 0, (Fields!Numerador.Value) / (IIF(Fields!Denominador.Value <> 0, Fields!Denominador.Value 0, 1), 0)
0 new messages