Subtraction Formula Showing incorrect answer

[rkeenan125]

Hi,

Not sure if this has happened with anyone but I'm trying to create a column that shows the difference between two others but some of the values are showing Null.

Column A - Column B = Column C

Example of what I'm seeing

$300 - Null = Null

I trying doing the Data Cleansing to replace with zeros but still getting 0 as the answer. They're all Doubles for the data type. 

Any input is appreciated. TIA.

[MelGibson · Accepted solution]

@rkeenan125 do you have a sample screenshot and/or workflow you can share. Can you filter for those that are showing null and verify that if null it updated to zero prior to the formula tool. Make sure you cleanse tool has the fields you want selected and that replace with 0 for numeric fields is checked

[rkeenan125]

Ahhh I realized I was doing cleansing too late into the workflow. Switch it's location and it worked. Thank you lol.