Table indicator based on Current year vs Last year

[Jonathan_Alm]

Hi,

I have a requirement that I am trying to solve.

Users want an indicator that says if Difference between Current year and Last year is more than 29% then Thumbs UP, if the difference is 20% or below than thumbs DOWN.

A mocked table can look like this:

	Current year	Last year
Total	10 000	7 800
Jan	1000 ^	500
Feb	1400 v	1300
Mar	1000 -	750
Apr	1000 ^	500

I am trying to use the table indicator but do now know if this can be evaluated like this per row?

Kind regards, Jonathan

[brunobertels]

Hello 

may be somethink like this : 

if(MesureCurrentYear / MesureLastYear > 0.29 , num(MesureCurrentYear, '#,## ▲ ' ) , 

if(MesureCurrentYear / MesureLastYear < 0.20, num(MesureCurrentYear, '#,## ▼ ' ), 

num(MesureCurrentYear, '#,## - ' )

))

[vinieme12 · Accepted solution]

This is not possible using "Indicators" as they compare against only one value and limits are not evaluated for each row

You can add a Text   ▲ ▼ to your measure though as below

=Dual(num(ExpressionCurrYear,'#,##0')&

if( 1- (ExpressionCurrYear/ExpressionLastYear)>0.29,'▲'

,if(1- (ExpressionCurrYear/ExpressionLastYear)<0.20,'▼','►')

, ExpressionCurrYear)