Struggling with the If statement

Syndicate_Admin · ‎10-08-2023

I have a column with numbers both negative and positive. Now i want to add a column that states 'negative' whenever a number is below 0 and 'positive' whenever its above. My formula is if([Transactiebedrag]=<0) then ([Transactiebedrag]= "negative") else ([Transactiebedrag]= "positive") . I keep getting an error where its expecting a token literal. Can anyone help me optimise the formula?

mussaenda · ‎10-09-2023

Hi @Syndicate_Admin,

watkinnc · ‎10-08-2023

Try

if [Transactiebedrag] <= 0 then "negative" else "positive"

--Nate

I’m usually answering from my phone, which means the results are visualized only in my mind. You’ll need to use my answer to know that it works—but it will work!!