Formula

[JoseGarcia]

Hi there, 

I do have a nested formula issue.

I need following calculation:
Total sum of calls divide by employees and contractors hours worked.

i've got formula below, but not giving me the result needed.

=sum(Sum([close calls]))/[Employee hours worked]+ [ Contractor hours worked]))

Can anyone help?
Thanks a million

Jose

[MayilVahanan · Accepted solution]

Hi @JoseGarcia 

Try like below

=Sum([close calls])/

(Sum([Employee hours worked]+ [ Contractor hours worked]))

Or

=Sum([close calls])/

(Sum([Employee hours worked])+ sum ( [ Contractor hours worked]))