Viewing 15 posts - 1 through 15 (of 60 total)
I tried both examples in attempt to exclude NaN:
(1)
=Val(replace(Sum(Fields!Reciept.Value) + Sum(Fields!Balance.Value)) / Count(Fields!VisitID.Value) ,"NaN","0"))
(2)
=IIF(Sum(Fields!Reciept.Value)>0,
Sum(Fields!Balance.Value)/Count(Fields!VisitID.Value)+Double.Epsilon),
nothing)
July 8, 2020 at 4:33 pm
I did try to research workaround but to no avail. Some of the examples offered...
July 8, 2020 at 3:57 pm
Gents,
First, thank you all for chiming in with the provided insight.
I have since upgraded to SQL Server 2017 for those who mentioned the usage of the older SQL Server 2008R2.
The...
September 7, 2019 at 11:57 pm
October 25, 2018 at 1:04 pm
Sorry for the late reply. Using the link supplied by pietlinden and...
December 19, 2017 at 1:32 pm
September 8, 2017 at 1:05 pm
September 8, 2017 at 10:53 am
Ed Wagner, your solution was very helpful. It provided me the insight that I was looking for, which is for the last discharge date for the said patient id, give...
May 31, 2017 at 10:41 am
Guys,
Sorry for the half ass post, I was kind in a rush and I was trying to formulate a code, but my code or approach was not making...
May 30, 2017 at 9:27 pm
May 9, 2017 at 9:11 am
May 9, 2017 at 9:06 am
May 9, 2017 at 8:34 am
May 9, 2017 at 7:32 am
Viewing 15 posts - 1 through 15 (of 60 total)