Hi geniuses, I'm stuck here with some indicators.
Here is my table:
[valueType] | [Value]
Allocation | 3000000
Value Planned | 5000000
I have to use a 4 Traffic Lights indicator where:
Green if Allocation >= Value Planned
Yellow if Allocation/Value Planned is > 0,7 and < 1
Red if Allocation/Value Planned is < 0,7
White if Value Planned is = 0
For the expression
valueType field name: valueType
Value field name: Value
The big problem i'm facing here is the indicator expression.
Thanks in advance!