Cannot convert value '+' of type Text to type True/False

[danextian]

Hello,

This is suposed to be a very simple conditional formula but I am actually stuck. 

Earnings Amount vs LY Variance % Arrow = 
SWITCH (
    TRUE (),
    [Earnings Amount vs LY Variance %] > 0, "+",
    [Earnings Amount vs LY Variance %] < 0, "-",
    BLANK ()
)
    && FORMAT ( [Earnings Amount vs LY Variance %], "0.00%" )

 

[danextian · Accepted solution]

Please ignore. I've figured it out. I used two ampersands "&" instead of one. 😄