If - I want it to return the original value of the column

[Jessica_Nakatake]

Hello everyone!

I need to get my IF to return the same number of the column I'm working with, but it keeps getting something wrong (don't know why...) - what I'm trying to do is to put all data back from 2013 equal to 2013, but after it I want to keep as it is.

Any ideas?

IF [AMY]<=2013
THEN 2013
ELSE [AMY]
ENDIF

[EKBS83]

Hi @Jessica_Nakatake, what error message are you getting, can you paste a screenshot of this part of the flow and your formula tool?

[Jessica_Nakatake]

Aye, there's no specif error I guess... seems a general one

Ohhhhhhh may be because it is not "double"?

[Jessica_Nakatake · Accepted solution]

I changed it to DOUBLE and now it worked kkkkkkk

[EKBS83]

Haha yep I was going to suggest maybe you have it in string form but you figured it out 😁 nice job!