Viewing 2 posts - 1 through 2 (of 2 total)
lynns (10/17/2013)
=AVG(IIf(Fields!SCORE.Value = "Unknown", Nothing, CDec(Fields!SCORE.Value)))
I think converting "Nothing" to a decimal creates the zeroes that are causing the...
October 17, 2013 at 10:15 am
#1659403
Daniel Bowlin (10/17/2013)I would probably use AVG and the OVER clause in TSQL to work this one out.http://technet.microsoft.com/en-us/library/ms189461.aspxLook at the examples under "Using the OVER clause with aggregate functions"
Daniel Bowlin (10/17/2013)
http://technet.microsoft.com/en-us/library/ms189461.aspx
Look at the examples under "Using the OVER clause with aggregate functions"
Hi Daniel,...
October 17, 2013 at 10:14 am
#1659402