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

# Formatting based on performance / participation

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.

• ###### 1. Re: Formatting based on performance / participation

OK so I don't think I've got it right in the first place.

I've got the participation by counting the number of deals done and then dividing that by 12 and multiplying by 100 to get the participation %.  However I noticed that it then splits up the values so all the 1's are on 1 row, all the 2's on the next and so on when I add the participation calculation.

How do I group these together so it's a 1 if there's a value in that month, 0 if it's blank.  Count those and then divide by 12 and multiple by 100?

• ###### 2. Re: Formatting based on performance / participation

Solved by Jim Dehner, 2 different but similar posts but Jim smashed them both!