3 Replies Latest reply: Jul 20, 2017 10:25 AM by Sunny Talwar RSS

    Combining scores expression help

    Gareth Lloyd

      Morning guys,

       

      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 Invoice Score %: Should be a combined score with (equal weighting) of FTMR% and EDI%. No matter what I try I just cannot get this to work. For instance, Jan should return an overall score of 83%.

       

      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,

      Gareth