Formula Help Needed

[granny1]

I need help in creating a formula for Company avg. per Location

 

[dgillz]

Most summary operations in Crystal are not created using formulas per se.

Right click on the value that you want to create an average per location on and then click insert-summary. Summarize by location and make the summary an average summary.

Let me know if you have any questions.

Don

Software Support for Sage Mas90, Macola, Crystal Reports, Goldmine and MS Office

 

[granny1]

Average per location is not an option on the insert summary tab. How do I do this.

 

[granny1]

Average per location is not an option on the insert summary tab. How do I do this.

 

[dgillz]

The only way average would not be available is if the data type is not numeric. try converting the field data to numberic with a formula and average summarize the formula field. Software Support for Sage Mas90, Macola, Crystal Reports, Goldmine and MS Office