Could be a Syntax problem?

[mama16]

Is this syntax oK?
I created this text box in the Report design view and added this
=Sum([Total])*Sum([Average_call_length])/18/60

I'm not getting the right answer?

 

[tledwards]

There is no way for us to tell if your formula is correct. If it's not giving you the answer you want it probably is not. The formula states:

Multiply Sum([Total])*Sum([Average_call_length])

Then divide that by 18
Then divide that by 60

 

[mama16]

Is it the same if I do this

Sum([Total])*(Sum([Average_call_length])/18)/60

I just want to know if the syntax is acceptable cause if it is then I have a data problem in the db.

I always appreciate your help,

Thanks