Help with standard deviation

[peggall]

I need to get the standard deviation of the number of orders written by location. I have a running total field to count the orders per location and I also created a formula field to count the total orders per location. I also have a formula that will give me the average number of orders per location.

I have tried writing a formula for the standard deviation using either the running total field or the formula field and with both I get an error, "This field cannot be summarized."

I am against a hard deadline and need some help. Please.

 

[lbass]

The standard deviation (population or sample) is one option in the summary dropdown list for both running totals and for the more usual summaries (right click on the field->insert summary).

-LB

 

[peggall]

I have seen the dropdown for the standard deviation in the running totals formulas but my running totals field does not appear for me to select. I am not quite sure what you are referring to by: (right click on the field->insert summary).

 

[lbass]

Why are you using running totals for the counts? I wonder if they are necessary. Please explain exactly how they are set up. There may be an alternative to using running totals.

Regarding inserting summaries--just to show you, pick some amount field and add it to the detail section. Then right click on it->insert summary and select a summary.

-LB