Select Field Type Null Value Not Summing

[sslattery17]

Need help with why my sum tool is not working correctly.  I have attached export workflow, screenshoots sample data and output on final result cvs file.

At the beginning of the workflow if I change the field type for deposit to double or fix decimal it errors.  If I replace null values with blanks for rent and or deposit the nulls appear again after the sum of data is not consolidating the data to a single row.  

Any help would be greatly appreciated.  

[sslattery17]

@JeffreyWolfe 

I attached a screen shot of the summarization tool and I adjusted the data cleansing tool for string fields and numeric fields still the same issue.

[sslattery17]

@nagakavyasri not sure why its not including the different schema multiple sheet macro but that is what is missing; I exported the workflow.  I attached the mulit sheet macro to add to workflow I sent and I add record id tool before selection tool.