Expression in query

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 adds
the 'sum' fields and divided the result by the 'count' field. Below is my
expression I am using:

Average: (([SumOfProcedures non-time based]+[SumOfTime Based
Units])/[CountOf# Hours Worked])

However, I get '#Error' as my result. This does not happen if I only add the
two sum fields:
([SumOfProcedures non-time based]+[SumOfTime Based Units])

What am I doing incorrectly?

Thank you,
Radhika
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top