I managed to get half way there with is using the below expression:
((Overall PO Score % *0.2)
(Overall Invoicing Score % *0.6)
(Overall Pay Score% *0.2))
This for the large part works, until one or more of the above scores is populated with a "-" due to not having any corresponding data. Any ideas on how I can amend my expression to mitigate the "-"?
I was thinking of replacing the "-" with either 100 or 0, but it's going to bump up or down their weighted score which would then be inaccurate.