4 Replies Latest reply on Aug 7, 2018 1:13 PM by Navid Tavoli

    WINDOW_CORR function works, but does not show the number in the sheet

    Navid Tavoli

      Hey everyone,

       

      I have difficulty showing the window correlation between two measures in a sheet.

      I have attached a superstore worksheet as an example. here is the formula

       

      WINDOW_CORR(SUM([Sales]),SUM([Profit]))

       

      when it is solely in the sheet, the value is null. Do you know how I can solve this problem?

       

      Thank you,

       

      Navid