Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am sorry, this should be basic stuff!
Looking at the below I am wanting to create a new column [TOTAL WORKLOAD] / [DISTINCT OPERATORS]
Formula's for each below:
[DISTINCT OPERATORS] = count(distinct OPERATORID)
[TOTAL WORKLOAD] = sum(WORKLOAD)
I was hoping this would work, but nup ...
sum(WORKLOAD) / count(TOTAL <DATE> distinct OPERATORID)
The first result should be ~5,955
Thanks!
Why not just sum(WORKLOAD) / count(distinct OPERATORID) ?
Hi @andrewc ,
Please try
Column(1)-Column(2)
1 and 2 would be your column position in the table.
Why not just sum(WORKLOAD) / count(distinct OPERATORID) ?
Uuurgh! I should have started with simple! Thanks Or!