Replace number within text column

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

Data Investigation

Accepted answers

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,

All comments

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,

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

Quick Links

Tags

This months top contributors

AkimasaKajitani 390

michael_weaver 335