Using Trend Arrows

Steve J Moss

I have a formula which works out the Net Days since an event occurred.

I have the following: [Event Type], [Days Since Last Event], [Day Before], [Trend]

 

The [Event Type] is the event I am searching for the number of days since the last one occurred. The Number of days appears in [Days Since Last Event], is a formula which works fine.

The [Day Before], is the same formula but is looking for the number of days yesterday, which is works fine.

 

What I am looking for is to define a formula that give the [Trend] of either up, down or across to display a trend arrow since yesterday. The difference between yesterday and today.

How would I do this?

regards

 

Steve J Moss

Andrée Starå

Hi Steve,

I'm not sure if this is what you're after but try this.

=IF([Days Since Last Event]@row > [Day Before]@row; "Up"; "Down")    

The same version but with the below changes for your and others convenience.  

=IF([Days Since Last Event]@row > [Day Before]@row, "Up", "Down")

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Would that work?

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting