You'll be better using AVG([Number of Records]) --
not SUM([Number of Records]) -- as your base calculation,
all other calc logic being the same. That's because your dataset
contains dirrefent number of rows for each Company.
Please find the attached workbook
(with the [Ability to discuss indications] done this way).
Hope this helps.
Z-Score_YF.twbx 171.5 KB