IfElse([<ADS SERVER\TCP\SLD\GENELINE>] == 0, "<FFFFFFFF>",
IfElse([<ADS SERVER\TCP\SLD\GENELINE>] <= 5, "<FFFF0000>",
IfElse([<ADS SERVER\TCP\SLD\GENELINE>] <= 15, "<FFFFFF00>",
IfElse([<ADS SERVER\TCP\SLD\GENELINE>] <= 25, "<FF00FF00>",
IfElse([<ADS SERVER\TCP\SLD\GENELINE>] <= 35, "<FF0000FF>",
IfElse([<ADS SERVER\TCP\SLD\GENELINE>] <= 45, "<FFFF00FF>",
IfElse([<ADS SERVER\TCP\SLD\GENELINE>] <= 55, "<FF808080>",
IfElse([<ADS SERVER\TCP\SLD\GENELINE>] <= 65, "<FFFFC0CB>","<FFFFFFFF>" ))))))))
how to change the text expression to something like this below
[<ADS SERVER\TCP\SLD\GENELINE>] == X,
IfElse(X == 0, "<FFFFFFFF>",
IfElse(X <= 5, "<FFFF0000>",
IfElse(X <= 15, "<FFFFFF00>",
IfElse(X <= 25, "<FF00FF00>",
IfElse(X <= 35, "<FF0000FF>",
IfElse(X <= 45, "<FFFF00FF>",
IfElse(X <= 55, "<FF808080>",
IfElse(X <= 65, "<FFFFC0CB>","<FFFFFFFF>" ))))))))
but its still got error in expression
i don't want to rewrite it all because there are so many object i've to change
thank you
IfElse([<ADS SERVER\TCP\SLD\GENELINE>] == 0, "<FFFFFFFF>",
IfElse([<ADS SERVER\TCP\SLD\GENELINE>] <= 5, "<FFFF0000>",
IfElse([<ADS SERVER\TCP\SLD\GENELINE>] <= 15, "<FFFFFF00>",
IfElse([<ADS SERVER\TCP\SLD\GENELINE>] <= 25, "<FF00FF00>",
IfElse([<ADS SERVER\TCP\SLD\GENELINE>] <= 35, "<FF0000FF>",
IfElse([<ADS SERVER\TCP\SLD\GENELINE>] <= 45, "<FFFF00FF>",
IfElse([<ADS SERVER\TCP\SLD\GENELINE>] <= 55, "<FF808080>",
IfElse([<ADS SERVER\TCP\SLD\GENELINE>] <= 65, "<FFFFC0CB>","<FFFFFFFF>" ))))))))
how to change the text expression to something like this below
[<ADS SERVER\TCP\SLD\GENELINE>] == X,
IfElse(X == 0, "<FFFFFFFF>",
IfElse(X <= 5, "<FFFF0000>",
IfElse(X <= 15, "<FFFFFF00>",
IfElse(X <= 25, "<FF00FF00>",
IfElse(X <= 35, "<FF0000FF>",
IfElse(X <= 45, "<FFFF00FF>",
IfElse(X <= 55, "<FF808080>",
IfElse(X <= 65, "<FFFFC0CB>","<FFFFFFFF>" ))))))))
but its still got error in expression
i don't want to rewrite it all because there are so many object i've to change
thank you