I have an expression like following =DATA_PDR-Today()-Tipo_Raggrup.TMP_GG that calculate delay on days compared with a standard appointment date. (sign "-" means "in advance" sign "+" means delay)
The maximum days and minimum days could be for istance 1000 days and -1000 (is it possible to set a formula that calculate that max and min value ?)
I need to set the Traffic LED gauge with three color.
RED means that calculation sign is positive and >0
ORANGE means that calculation result i 0
GREEN means that calculation sign is negative and <0
I set Lower bound Red to 1 Orange to 0 and Green to -1 but the result is really bad.
