Averages

[LG]

I have a query built to find out how many days are between Submit_Date and
DOF. I am trying to get the average of all the days. I have tried the
Average group and also expression but keep getting an error any suggestions.

 

[KARL DEWEY]

Edit your query this way --
Num_Of_Days: Abs([Submit_Date] - [DOF])

Remove any other fields from the row.
Click on the Totals icon that looks like the letter 'M' on its side - ∑
In the Total row select Average.

 

[LG]

Maybe i was unclear. I tried your below suggestion and got the same result
as my 1st query. I need to I guess take that total number of records (count)
/ by the total Number of days?
Would you have any ideas

Edit your query this way --
Num_Of_Days: Abs([Submit_Date] - [DOF])

Remove any other fields from the row.
Click on the Totals icon that looks like the letter 'M' on its side - ∑
In the Total row select Average.

I have a query built to find out how many days are between Submit_Date and
DOF. I am trying to get the average of all the days. I have tried the
Average group and also expression but keep getting an error any suggestions.

 

[KARL DEWEY]

Edit your query this way --
Num_Of_Days: Abs([Submit_Date] - [DOF])

Remove any other fields from the row.
Click on the Totals icon that looks like the letter 'M' on its side - ∑
In the Total row select Sum.

Then click on DOF and drag to the Field row.
In the Total row select Count.

Save query as Days_Submit_Date_DOF

Create another query using Days_Submit_Date_DOF for the data.

In field row enter --
My_Average: [Num_Of_Days]/CountOfDOF

Run query.

Maybe i was unclear. I tried your below suggestion and got the same result
as my 1st query. I need to I guess take that total number of records (count)
/ by the total Number of days?
Would you have any ideas

Edit your query this way --
Num_Of_Days: Abs([Submit_Date] - [DOF])

Remove any other fields from the row.
Click on the Totals icon that looks like the letter 'M' on its side - ∑
In the Total row select Average.

I have a query built to find out how many days are between Submit_Date and
DOF. I am trying to get the average of all the days. I have tried the
Average group and also expression but keep getting an error any suggestions.

 

[LG]

That worked thanks

Edit your query this way --
Num_Of_Days: Abs([Submit_Date] - [DOF])

Remove any other fields from the row.
Click on the Totals icon that looks like the letter 'M' on its side - ∑
In the Total row select Sum.

Then click on DOF and drag to the Field row.
In the Total row select Count.

Save query as Days_Submit_Date_DOF

Create another query using Days_Submit_Date_DOF for the data.

In field row enter --
My_Average: [Num_Of_Days]/CountOfDOF

Run query.

Maybe i was unclear. I tried your below suggestion and got the same result
as my 1st query. I need to I guess take that total number of records (count)
/ by the total Number of days?
Would you have any ideas

Edit your query this way --
Num_Of_Days: Abs([Submit_Date] - [DOF])

Remove any other fields from the row.
Click on the Totals icon that looks like the letter 'M' on its side - ∑
In the Total row select Average.

:

I have a query built to find out how many days are between Submit_Date and
DOF. I am trying to get the average of all the days. I have tried the
Average group and also expression but keep getting an error any suggestions.