I'm trying to paint a kpi when it's greater than 0.95 that is green otherwise it's red, I'm using the column () function but apparently I'm doing something wrong.
IF (Column(4) >0.95, RGB(0, 255, 0), RGB(255,0,0))
Be aware that the column number starts counting at the first measure column - it disregards the dimension columns.
So it looks like it is column number 3 that you should test for:
If( Column(3)>0.95, RGB(0,255,0),RGB(255,0,0))
It worked for me, I had a bad concept of this function but you have helped me to understand it.
Thansk a lot Petter.
Retrieving data ...