Forum Discussion

danextian's avatar
danextian
Icon for Super User rankSuper User
7 years ago
Solved

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

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%" )

 

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

1 Reply

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