Expression doesn't works

[fgauthier]

Hello,

Anyone can tell me whats wrong with this expression.

Code: Select all

{IIF(Trim(ToUpperCase(ResultatsDerniersLotsView.codeMeilleur)) == "MAX" , 20 , 40)}

It always return 40 even if the value of ResultatsDerniersLotsView.codeMeilleur is "MAX"

[fgauthier]

Attached is the mrt file

[Lech Kulikowski]

Hello,

Please send test data for your report.

Thank you.

[fgauthier]

Here is the table in JSON

[Lech Kulikowski]

Hello,

Unfortunately, it is not possible to use such an expression for Gauges.

Thank you.

[fgauthier]

Can you tell me whats wrong with it? And what can i use instead ?

[Lech Kulikowski]

Hello,

Please explain what result do you need?

Thank you.

[fgauthier]

In fact, i was doing test with the expression. I need it in the range property of the gauge. I need to reverse the color range when the field value is "MIN". Is the expression will work in the range expression ? I actually dont have acces to the version that provides the expression in range.

[Lech Kulikowski]

Hello,

Unfortunately, no.

Thank you.

[fgauthier]

Hello,

Is there a way to reverse the color of a gauge with blockly?