Trend Analysis

[rcorcoran]

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

[rubenmarin · Accepted solution]

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.

[rcorcoran]

Hi Ruben

Thank you so much for your time this is perfect.

Rhona