0 Replies Latest reply: Aug 9, 2012 10:37 PM by Chien-sheng Tsai RSS

    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. 

       

       

      DB_QV_ActualDays.jpg

      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. 

       

      Any advice and comments would be welcomed. 

       

      Thanks.