Calculations, Aggrregation, and Handling of Nulls


#1

Hi,

Sometimes the calculated target rate and points are null, in which case, ROA is also null. The target interest rate, points, and ROA aggregate calculations should exclude the null values. Any idea why the calculations are off? If I weight the values based on loan amount will this correct the issue?

Thank You,
Nick

2018-03-30_10-31-56


#2

Please disregard. Not sure how to delete.