R
Radhika
I am trying to create a query form another query which takes the sum of two
fields and the count of a third. The query I am trying to create should add
the 'sum' fields and divided the result by the 'count' field. Below is my
expression:
Average: (([SumOfProcedures non-time based]+[SumOfTime Based
Units])/[CountOf# Hours Worked])
However, I get' #Error' as my result. This does not happen if i simply add
the 'sum fields':
([SumOfProcedures non-time based]+[SumOfTime Based Units])
What am I doing incorrectly?
Thank you,
Radhika
fields and the count of a third. The query I am trying to create should add
the 'sum' fields and divided the result by the 'count' field. Below is my
expression:
Average: (([SumOfProcedures non-time based]+[SumOfTime Based
Units])/[CountOf# Hours Worked])
However, I get' #Error' as my result. This does not happen if i simply add
the 'sum fields':
([SumOfProcedures non-time based]+[SumOfTime Based Units])
What am I doing incorrectly?
Thank you,
Radhika