Hi

I've created a PDI which basically shows weekly spend on energy at numerous buildings on one of my companies sites. Using performance equations I've created a coloumn which displays the difference in spend between the previous week and the week previous to that (hope that makes sense). What I'd like to do is add to the display an arrow which displays if the weekly spend has increased or decreased (green arrow up for decrease in spend, red arrow down for increase in spend).

I can obviously add the arrow but I'm unsure how to develop the method of how the arrow changes when spend increases / decreases. I'm a bit of a newbie so apologies if this a bit vague. I've read through the process book manual but struggling to find anything which points towards this.

Many Thanks in advance

Hi Darren

A simple method I've used before would be to create a Performance Equation returning 0, 1 or 2 (or possibly -1, 0 or 1) according to the three outcomes of this. If it's a weekly number only to be compared to last weeks number, you can just use simple PE functionality to compare this week's number to PrevVal(...).

In ProcessBook you'd use a multi state functionality on three graphical symbols. I've found it best to use symbols without a black border, and then place the three so that they overlap. The multi state will have to be set up so that the color is transparent (none) when it's out of state, and a good color when the state matches your arrow. I used a green arrow pointing upwards for a positive number, a yellow arrow pointing straight forward for the 0 number (same as last week), and a red arrow pointing downwards for a negative number.

If you need a more advanced calculation on determining the slope of a trend, you'll be looking at calculating the derivative for the trend. I think there's a function in PE called Arma, but I haven't used it.