This content has been marked as final. Show 3 replies
I'm after some more expression help if I may please!
In the sample data attached I'm trying to create the following overall scores for a dashboard. The three scores I'm stuck on are as follows:
Overall PO Score %: Should be a combined score of (with an equal weighting) PO's with GRN% and Retro PO's %. As you will see, the Retro PO% visual cue is the opposite of GRN% as 0% is positive in this case. I haven't the first clue how to write an expression that comprises their overall score!
Overall Pay Score %: Should be a combined score with (equal weighting) of Outstanding Inv. Value % and Invoices Overdue %. For both of these, 0% is the best score possible and 100% is the worst. However, for their combined score, I want 0% to be the worst and 100% to be the best - again I've no idea how to write an expression for this.
Many thanks in advance,