Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I am trying to get the trend in the attached with an up arrow, down etc depending on the max month v previous month.
It has worked for me with a different metric that wasnt a percentage. I think my brackets are wrong but cant seem to fix it.
Any help appreciated.
Table on attached file
Rhona
Hi Rhona,
Changed brackets in if, match and sum comparison clauses, also some brackets left in set analysis, check attachment to see if that's what you are looking for.
Hi Rhona,
Changed brackets in if, match and sum comparison clauses, also some brackets left in set analysis, check attachment to see if that's what you are looking for.
Hi Ruben
Thank you so much for your time this is perfect.
Rhona