This content has been marked as final.
Show 2 replies

1. Re: How do I calculate Standard Deviation of an aggregated field
Jonathan Drummey Jul 10, 2012 10:08 PM (in response to Ishan Sharma)Hi Ishan,
Since the Selling Rate is an aggregate, other aggregation functions won't work on top of them, as you found out. However, table calculations can perform as many levels of additional aggregation as necessary (though there are practical limits as far as performance and partitioning). So instead of STDEV([Selling Rate]), use WINDOW_STDEV([Selling Rate]) and you should be all set.
Cheers,
Jonathan

2. Re: How do I calculate Standard Deviation of an aggregated field
Ishan Sharma Jul 11, 2012 4:00 AM (in response to Jonathan Drummey)Hey Thanks a lot
Ishan