April 3, 200223 yr Newbies 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
April 3, 200223 yr 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.
Create an account or sign in to comment