standard deviation

[ed@stoneage]

I've created four fields that have imported calculated, totals of sales (for each part that we sell), for month, quarter, half and year. I would like to now multiply the month by twelve, the quarter by four, the half by two and then find the standard deviation of these four fields. Does anyone have a suggestion on how to do this?

Thanks

[Fitch]

First create calculated fields for Month * 12, Half * 2, and Quarter * 4.

Then use:

StDev(MonthCalc, QuarterCalc, HalfCalc, Year)

Look up "standard deviation" in the online help for more info.

[ed@stoneage]

Thanks. I appreciate you taking the time to help.