That makes sence.

So its really a matter of SQL Server returning NULL instead of #ERROR not having the correct syntax which obviously means that a FROM clause needs to be included.

So the point proven is more like SQL Server returning a 'value' instead of an error.

And not that it can't calculate 🙂 (and is has nothing to do with a zero division)

'cause my point was that std. dev. is 0 if calculated on a single value no matter what it is (even if that makes no sence)

Question good, formula good, Microsoft needs to work on documentation

We're all happy

Cheers