Calculations, Aggrregation, and Handling of Nulls



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,



Please disregard. Not sure how to delete.