Compare values to each other in a chart

[#1]

I have a chart with the dimension Year and Expression Sum(Profit).

How do I write an expression to check if the profit for one year has increased or decrease since last year?

In other words, profit Year X is larger than profit Year X-1. I know it's possible to call the variable Year but not how to compare it with another Year variable...

[Oleg_Troyansky]

use function above() to get the previous value - if you chart dimension is "Year", then the previous value will be the value from the previous Year.

[#3]

Hi Oleg,

This does indeed work, but for me sometimes it does not...

Attached I created an example for which the above function only displays a '-' ...

Very strange... but probably for a reason 🙂

Regards,

Maarten

[pat_agen]

hi,

this is because you are using several dimensions in your charts.

In this case you must use the function above() with the qualifier TOTAL. like this

above(total aValue)

[#5]

Hi,

Thanks! That did indeed fix it!

10Q!

Have great day!

Maarten