calculation help. Formula tool

[florayaoyao]

Hi Everyone, 

I have a very simple data flow with a new calculated field: 30+ Aging. 

I used the formula just as below: and all fields are double type..  The result of 30+ is null.... why would that be ?  

[31-60 days]+[61-90]+[91-120]+[121-150]+[151+]

I attached a sample workbook. someone please help! 

Thank you!~~~

Flora 

[Bob_Blackey · Accepted solution]

Hi Flora,

I can't see the data as the spreadsheet wasn't attached, but I would try inserting a Data Clensing tool to convert any nulls to 0.

I would also look at the Select tool and make sure that 30+ is number field.

Cheers,

Bob

[florayaoyao]

Hi Bob,

The cleansing tool actually help! I need to convert the null to 0 in all aging buckets,  Then the new calculated field 30+  would return numeric values. 

Appreciate your quick help! 

Thank you! 

Flora