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

@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