sql server reporting services: Infinity -- sql server reporting services

You're in the

sql server reporting services

group:

Infinity

William Stacey [MVP]
1/26/2006 6:08:02 PM

sql server reporting services:

First row show "Infinity" with this calc.
=((Fields!Total_Rooms.Value - Previous(Fields!Total_Rooms.Value))) /
Previous(Fields!Total_Rooms.Value)

How to not show "Infinity" on first row? TIA
--
William Stacey [MVP]

Re:Infinity

saras
1/27/2006 12:00:00 AM

Use the following expressing
"=IIF(IsNothing(Previous(Fields!Total_Rooms.Value)),
0,
(Fields!Total_Rooms.Value - Previous(Fields!Total_Rooms.Value)) /
Previous(Fields!Total_Rooms.Value))"
In the mentioned expression, u can replace "0" with the value u want to

Re: Re:Infinity

William Stacey [MVP]
1/27/2006 9:46:09 AM

Thanks saras.

--
William Stacey [MVP]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.

home · blog · groups

Questions? Comments? Contact the dn