Hi there,
I have a small problem. I have some fields that I need to add into a new field called "Total Population".
However, when i add them together, it comes up with "Null", and I do not understand why. All the fields going into the formula tool are numeric, so they should add up, right?
Or is there someting I miss?
Solved! Go to Solution.
Hi @olehr if your fields a string type that would explain why the formula is not working. Could you share an example of the data or workflow you are working on ?
Hi Ben,
I tried to use the clensing tool, and then it reports 0 instead of Null. What I do not understand is that it has worked before, and all that goes into the formula tool are Int64. So this is a puzzle to me.
Hi again,
For some reason, when i closed alteryx, and reopened it, it did work. Wierd!. Anyhow, thanks for the help 🙂