Workflow & Conversion Errors

[sslattery17]

Have been working on this workflow for a few weeks with ongoing issues.  The ultimate goal is to have a single row of data that sums in each charge code category Rent, Deposit, Pet Rent, Garage, Carport, Parking etc...

Issue 1 - Numeric fields (Deposit Held & Scheduled Charges) coming in txt type; changed to number but receiving a TONUMBER:Deposit Held lost information in conversion and Error Limit Reached on both. 

Issue 2 - I have tried just changing with selection tool and received other errors. 

Issue 3 - Unable to get to a single row.

The two spreadsheets are similar but pulling some information from one and only 1 column [floor plan] from another.

Can someone help solve the two issues having with this workflow?  Attached Workflow, Sample Data, Screenshots

If there are ideas to restructure to get to the ultimate goal I am open.  Thanks in advance.  

[ChrisTX · Accepted solution]

For Issue 1 - Numeric fields

The number one rule: know your data

After the Input tool, where your numeric data is still stored as Text, add a Browse tool.  Sort the Deposit Held field.  Scroll to the top and bottom.  Are there values that will not convert to a number? Blank or null values?  Are you converting to a Fixed Decimal or Double?

The ToNumber function has parameters for Ignore Errors and Keep Nulls.  Try creating a new Numeric field by using a Formula tool with the ToNumber function and using different options for those parameters.

ToNumber(x, [bIgnoreErrors], [keepNulls], [decimalSeparator])

Chris