In this situation, I am showing a report of outstanding loans. Each loan has an 'Amount Outstanding' and a 'Total Credit Line' field. Each loan also has a 'Amount Outstanding as a % of Total Credit Line' field.
I would like to display the 'Total Amount Outstanding of All Loans as a % of Total Credit Line of All Loans', however, just showing an average of the individual % fields would not be accurate because it is not a weighted average. How can I show this weighted average on a report (to then display on a dashboard)?
EDIT: Ok, it looks like I can add a Formula Field to a summary report that will calculate the :SUM of each of the columns, then divide one by the other. This is working, however when I click 'OK' after defining the formula, it is not getting added to the report preview, and it won't let me drag it on. Any idea why this is happening?
Thanks!