Could you share a sample workbook or some screen shots to show how the percentage is currently calculated and field names
this would help the community answer your question
2 of 2 people found this helpful
not sure if i have answered the question correctly, (plus the numbers in your dummy workbook don't match the ones in the image above).
Instead of averaging 4 % scores i created a calculated field that checked all 4 measures and flagged any record that failed 1 of them (so will miss double counting where 1 machine fails more than 1 test) and then created a percent that failed any - you can see in the attached workbook.
if you want to calculate a % that takes into account a machine failing 2 or more of the tests let me know and i can knock that up for you.
Thanks for the fast reply. Having looked at your calc and the reasoning I think your way is a much more logical way to calculate the overall health against the 4 checks. Thanks so much I can use this in my work now. I owe you one!
Hi Tony please see attached.
File was created in 9.3
Let me know if you have any issues and I can either provide screen shots or help you downgrade
Hope this answers your issue.
If you need further assistance please let me know.
should read the thread before answering. - I was too late.
I love that about the community someone is always there to pick up the slack when you get caught up with other work. Thanks Chris.