Has anyone used the standard deviation function in BusinessObjects? I have found that with a very small number of rows in the data provider (10-20), BusinessObjects gives a result close to what I would expect and have verified the result with Microsoft Excel. However, I am wanting to use this function with a much larger set of data (20,000 - 500,000 rows) and have found that as I increase the number of rows in the data provider, the BO function gives a result that increasingly varies from what I would expect and what is given by Excel. I have demonstrated this phenomenon to BO tech support, but they claim this is the first complaint of this kind and they believe the Standard Deviation function is working properly.
I would appreciate any posting of other experiences with this function.
Thanks,
Spencer R. Stout
Infometric Systems Corp.
sstout@sjmc.org
Listserv Archives (BOB member since 2002-06-25)