1 of 1 people found this helpful
Question1: Subtotal is wrong because your calculation is not aggregated. if you use Sum(Total Loan Amt )/ Sum(Total Appraised Value) in the calculation then you will get the correct subtotals.
Question2: If you provide more details on the calculation or sample workbook then forum members can answer.
Issue 1: Subtotal issue of "Loan to Value" is fixed after changing the calculation to Sum([Loan Amount by Ownership %])/Sum([Appraised Value (MM)]) .
Issue 2: Weighted calculation subtotal & grand totals are not working because it contains" ATTR(Coupon)" which is returning "*" for second subtotal (because multiple coupon values) and null for third subtotal, though It is showing first subtotal accurately since attribute "Coupon" got only one value 5.27 %.
I would suggest you to create a business logic to provide some default values for blank or null "Coupon" as well as for subtotal "coupon" calculation (like avg ..etc).
Thanks Indumon, I was able to fix the first issue by doing exactly what you recommended and I added the Avg function so that way it would calculate the totals properly.