Hi I am doing a project for school and this one step seems really simple but I can't figure it out.
"Use a formula tool connected to the true output anchor of the Filter tool for Step 2
Part 7 to add a new column labeled "Pretax Income – Domestic" which is equal to
[IncomeLossFromContinuingOpeartionsBeforeIncomeTaxesDomestic]"
I tried just setting the formula as =[IncomeLossFromContinuingOpeartionsBeforeIncomeTaxesDomestic] and I keep getting an error message. I can't think of any other way to just straight up make a new column contain an old column's data, because it doesn't seem like something I would need a full conditional statement for. Any help would be appreciated!
Hi, @mwwood
1- First, you need define a name for new field .
2- Just like you said, only input old field name in expression box, don't need "=".
[IncomeLossFromContinuingOpeartionsBeforeIncomeTaxesDomestic]
3- Make sure the data type of the new field and the old field are the same.
Hi @mwwood ,
I think the problem is that your expression is empty.
If you create a column with the formula tool without an expression below, you will get an error message.
Attached is a stream where I create exactly the requested column being a result of a product by 2 with an existing column. You can modify it as you want, I made this calculation just as an example.