topic Re: Function Column() in Brasil

Function Column()

MarioCenteno — Wed, 22 Aug 2018 15:20:06 GMT

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.

Current expression:

IF (Column(4) >0.95, RGB(0, 255, 0), RGB(255,0,0))

Re: Function Column()

michaelsikora — Wed, 22 Aug 2018 15:36:08 GMT

Mario,

Instead of using the column function, try going to the expression and clicking the plus arrow. Once doing that you double click "Background Color".

Then use the expression in in column 4 (instead of sum(NetSales), use your expression) like below:

If(Sum(NetSales)>.95, RGB(0,255,0), RGB(255,0,0))

Re: Function Column()

MarioCenteno — Wed, 22 Aug 2018 15:42:42 GMT

I was already doing so but my expressions are too long, so I try to reduce the code with the column () function.

Re: Function Column()

michaelsikora — Wed, 22 Aug 2018 15:47:17 GMT

IF (Column(4) >0.95,RGB(0,128,0), RGB(230,0,0))

Re: Function Column()

MarioCenteno — Wed, 22 Aug 2018 15:50:55 GMT

It does not work, I have the same function and apparently there is some error.

Re: Function Column()

michaelsikora — Wed, 22 Aug 2018 15:54:49 GMT

Try Column(3) and make sure the number is an integer.

Re: Function Column()

MarioCenteno — Wed, 22 Aug 2018 16:08:15 GMT

It worked in the following way

If (Column( 3 )> 0.95, RGB (0.255,0), RGB (255,0,0))