Calculations in a Sum Query

[Jasper Recto]

I have a query that sums up several columns and gets a count from one
column. Is it possilble to make anther column that takes the sum value of
the the first few columns and divide them by the count of the last column?

I can't seem to make a equation that uses the sum values in its own query.

Is this possible or do I need to create a new query just for the specific
function?

Thanks,
Jasper

 

[Ryan]

Yes, you can add a calcualtion in another column. Your new column would look
like this.

GrandTotal:[TheNameOfYourCalculationsColumn]/[TheNameOfYourCountColumn]

If you have totals in your query, be sure to make the total an expression.

You do do everything in one column if you wanted.

GrandTotal[Field1]+[Field2]+[Field3])/[Count]

 

[Jasper Recto]

THANKS!!!

Yes, you can add a calcualtion in another column. Your new column would
look
like this.

GrandTotal:[TheNameOfYourCalculationsColumn]/[TheNameOfYourCountColumn]

If you have totals in your query, be sure to make the total an expression.

You do do everything in one column if you wanted.

GrandTotal[Field1]+[Field2]+[Field3])/[Count]
--
Please remember to mark this post as answered if this solves your problem.

I have a query that sums up several columns and gets a count from one
column. Is it possilble to make anther column that takes the sum value
of
the the first few columns and divide them by the count of the last
column?

I can't seem to make a equation that uses the sum values in its own
query.

Is this possible or do I need to create a new query just for the specific
function?

Thanks,
Jasper