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

    Linest_M not working

    Frank Beunder



      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!