Kelli Webb
Member
Hi All,
I've used this calculation before without issue, but for some reason it is not working for me today.
In the attached, I just want the calculation to show as a % of the total in cell B12
I have provided what the variance should be in column D
I'm sure it is a quick fix, but I'm really struggling and your help would be greatly appreciated.
kind regards,
Kelli
I've used this calculation before without issue, but for some reason it is not working for me today.
In the attached, I just want the calculation to show as a % of the total in cell B12
I have provided what the variance should be in column D
I'm sure it is a quick fix, but I'm really struggling and your help would be greatly appreciated.
| Wrong Calc | |||
| Roles | Count | Variance | Should be |
| Admin | 3 | 3233.33% | 3.00% |
| Branch Manager | 6 | 1566.67% | 6.00% |
| Cashier | 7 | 1328.57% | 7.00% |
| Department Manager | 32 | 212.50% | 32.00% |
| Payroll Manager | 7 | 1328.57% | 7.00% |
| Reporting Advisor | 28 | 257.14% | 28.00% |
| Supervisor | 3 | 3233.33% | 3.00% |
| Technical Lead | 14 | 614.29% | 14.00% |
| Grand Total | 100 | 0.00% | 100.00% |
Kelli