Replace number within text column

[adombayeva]

Hello, I'm new in Alteryx and have an issue which cannot solve. 

I have set up the condition for value, so in 'Purpose' column it suppose to pick up the right text (forecast, planned or actual). But when it comes up to the ''actual" instead of using it as a word, it takes it's value. Could you please advise how to solve it, so under "Purpose" will be all text?

The situation is as follows:

Metadata:

Thanks,

Anar

[Thableaus]

Hi @adombayeva 

You probably referenced Actual in your IF statement as a column, that's why it's taking a value from it, make sure you quote it like this:

"Actual"

Cheers,

[adombayeva]

Hello,

Thank you for support,

Please find my 'IF' condition:

It seems you are right, then when I change it to "Actual" it gives me the following error:

How to write it in correct way?

Thanks

[Thableaus · Accepted solution]

@adombayeva 

The "Value" calculation is under the numeric values. So you need to keep [Actual] as it is.

From my point of view, the only change you need to make is in the Purpose Column.

Just to make it clear:

[Actual] - References values under the column Actual.

"Actual" - References the string (the word) "Actual" 

Cheers,

[adombayeva]

Hello #Thableaus,

Thank you very much, it works!

Have a wonderful day! 

Going to crack further. This journey will not be an easy 🙂

Cheers