2 Replies Latest reply: Dec 7, 2012 1:04 PM by Frank Beunder RSS

    Linest_M not working

    Frank Beunder

      Hello,

       

      I have a very easy data model and I like to calculate the LINEST_M value (Trend line)

      I have a field that represents a Year_Quarter = [%KwartaalJaar], a category = [ProjectPrestatie_Onderzoeksveld] and a value field = [PP_Cijfer]

       

      I like to calculate the LINEST_M for the Categories over the Quarters, I use the following expression:

       

           LINEST_M( AGGR(AVG(PP_Cijfer), %KwartaalJaar),%KwartaalJaar)

       

      But I don't get a value, what am I doing wrong??

       

      See attached document

       

      Thanks in advance!

      Frank