Solved: Formula - Qlik Community - 1760812

Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.

Skip to main content

Qlik.com | Qlik Services| Qlik Help |

Ask a Question

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

1 Solution

Accepted Solutions

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]))

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

View solution in original post

1 Reply

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]))

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.