5 Replies Latest reply on Dec 17, 2014 12:09 PM by luciana.suran

    Calculate WINDOW_AVG on table for only those IDs with no missing values?

    luciana.suran

      Hi,

       

      I would like to calculate a WINDOW_AVG on a table but only for those IDs that have a valid rating for each date in the window. In this case, I want to calculate a WINDOW_AVG that includes only companies AAA, CCC, and EEE since they have a rating for each date. This should be 3.3333.

       

      I've tried filtering out companies with missing values but when I calculate a WINDOW_AVG the data for the companies with missing data is still used in the calculation even though they are hidden from the view.

       

      Anyone out there with a tip? I'm sure there is a simple solution but I can't solve it...

       

       

      Thank you!

       

       

       

       

      Untitled.png