Standard Deviation in SSRS

Question

Standard Deviation in SSRS

sheba.sql

Old Hand

Points: 314
More actions
June 28, 2018 at 8:36 am

#352424

Hi,
I am calculating to Standard deviation and i am using standard deviation function, i am doing stdev(Fields!Column1.Value/Fields!Column2.Value) and i get #error value, is it due to null values, if so how to eliminate the #error.
Thank You!

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Luis Cazares SSC Guru Points: 183706 More actions · Answer 1

sheba.sql - Thursday, June 28, 2018 8:36 AM
Hi,
I am calculating to Standard deviation and i am using standard deviation function, i am doing stdev(Fields!Column1.Value/Fields!Column2.Value) and i get #error value, is it due to null values, if so how to eliminate the #error.
Thank You!

Are you sure that is caused by null values? Could you have any zeros in Fields!Column2.Value?

Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

How to post data/code on a forum to get the best help: Option 1 / Option 2

sheba.sql Old Hand Points: 314 More actions · Answer 2

I just checked my dataset, there are no zeros in Fields!Column1.Value or Fields!Column2.Value. Either both have null values or both are not nulls, not sure what the reason. Working from Hrs to figure it out 🙂 @luis C.

sgmunson SSC Guru Points: 110640 More actions · Answer 3

sheba.sql - Thursday, June 28, 2018 9:17 AM
I just checked my dataset, there are no zeros in Fields!Column1.Value or Fields!Column2.Value. Either both have null values or both are not nulls, not sure what the reason. Working from Hrs to figure it out 🙂 @luis C.

I'm pretty sure NULL values aren't going to work. You can't compute a STDEV and have NULL values in the group. You'll have to eliminate those first.

Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)