2 Replies Latest reply on Jan 25, 2018 9:44 AM by John Powell

    Formatting based on performance / participation

    John Powell

      Hi all

       

      We have a participation report where the number of deals done per month is displayed as a count.

       

      What I'm trying to format is that when a person does not do a deal for 2 consecutive months they are coloured red (ideally the whole row) and then turn the line yellow for example if their participation rate falls below 40% which I think I've got via a field for IF [Participation %] <40 THEN 'AMBER' end and applying that to the colour mark but if there's a better way of doing it I'm all ears (not in this work book, literally wrote it as I was writing this and realised it should just be that).

       

      Participation is achieved through a calculated field that is always based on 12 months and not year to date.