Traffic Lights Issue

[Former Member]

Hi all,

I'm trying to set up some traffic light alerts with visual composer and having trouble to specify the right conditions.

When I put conditions with negative numbers (i.e. "deviation<-10") the alert disappears. I've tried many combinations such as "deviation+10<0" or even writting the formula with the means of deviation, like "real>objective*0,90". But nothing seems to work properly. Any ideas?

Thanks a lot in advanced!

Best regards,

[Former Member · Accepted solution]

Hi Roger,

I'm not sure what expression you are building but you may find it useful using the sign function to check if the value is negative and if so work with abs(<value>).

(

see more details about functions in:

http://help.sap.com/saphelp_nw70/helpdata/en/bd/90db4238bbf140e10000000a1550b0/frameset.htm

)

Hope this helps.

Regards.

Omer.

[Former Member · Accepted solution]

HI Omer,

I've already tried working with abs but it doesn't seem to make any difference.....

Thanks anyway,

[Former Member · Accepted solution]

I see, any chance you are working with a string value?

if so, you can try working with abs(int(value)).

Regards.

Omer.

[Former Member · Accepted solution]

Also tried, and nothing.

Any more ideas? I've run out of them...

Thanks!

[Former Member]

hi,

is data coming from BI?

[Former Member]

FInally solved taking some boolean arguments:

For green light: BOOL(IF((@F3Desviac_1_value>-1),'1','0'))

For yellow light: BOOL(IF((@F3Desviac_1_value>-10),'1','0'))AND BOOL(IF((@F3Desviac_1_value<-1),'1','0'))

For red light: BOOL(IF((@F3Desviac_1_value<-10),'1','0'))

Thanks anyway,

[Former Member]

Hi,

Any ideas?

Thanks,