Average of Hours over Days used

[Doofguru]

Hi Everyone,

I am trying to make a calculation for our service database what I'm trying to do is as follows.

date machine setup 1/8/09

date machine in for service 10/8/09

= 10 days

machine was used for 16 hours, 16 divided by 10

= 1.6 hours per day

so how I'm trying to do it is as follows.

i have 3 fields

One

Used hours calc field: Hours Out - machine hours = x

used days calc field: Date out - Setup date = x

Daily Average field: ( "maintenance: 1: Average Hours" ; "maintenance: 1: Average Days" )

But it is returning -2990000 i have obviously done something really dumb, but i just don't get it.

Can anyone help???

[Vaughan]

Check that the "Hours Out" and "Machine Hours" fields are number fields, and the "Used Hours" cal is set to return a number.

Check that the "Date Out" and "Setup Date" fields are date fields, and the "Used Days" calc is set to return a number.

You haven't explained what the "Daily Average field is or where the

fields for this calculation come from.

Finally, check that all the fields have valid data in them. Without valid data the calculation fields will never return the expected results.

[Doofguru]

Yep that got it. forgot to change them to dates and numbers. thanks heaps for that!