4 Replies Latest reply on Oct 10, 2013 12:22 PM by taylor.johnson

Hide/Show Certain Subtotals

Hello,

I attached a picture that depicts what I would like to do:

• In red I would like to hide those subtotals (mainly because it is being computed wrong).  For the first section (In Progress) the total LTV should be the Total Loan Amt (\$210) / Total Appraised Value (\$432) = 48.6%.  Instead the percentage value is being SUM'd.  The field titlted 'Loan-to-Value' is a calculated field.
• In green the subtotal for the Weighted Coupon is not being SUM'd in the subtotal line.  How can I resolve this?

Thanks!

• 1. Re: Hide/Show Certain Subtotals

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.

1 of 1 people found this helpful
• 2. Re: Re: Hide/Show Certain Subtotals

Hi Indumon,

Please take a look at my attached workbook.

Thanks

• 3. Re: Re: Hide/Show Certain Subtotals

Hi Taylor,

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). • 4. Re: Re: Hide/Show Certain Subtotals

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.