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]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
display.|||Thanks saras.
--
William Stacey [MVP]
No comments:
Post a Comment