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
Solved! Go to 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
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