Question: Calculating Average Balance for Actual Days Outstanding
Hello all, need your help.
I have an app that needs to calculate the average loan balance outstanding for the month. However, I cannot simply take the average of the sum of the daily balance and divide by the number of calendar days in the month, since these loans are only outstanding for a few days--it is a stock lending operation. What I need is to calculate the balance only for the days that the loan is actually outstanding during the month.
I developed this generic example. I copy and paste an image below, and also attach this example as an Excel file.
As shown, I want the Actual Average by Days Outstanding in Row 36. This Average I calculated using CountIF in Excel. I don't know how to do so in QlikView.