Linest_M not working

[beunderf]

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

[swuehl · Accepted solution]

Your %KwartaalJahr is non-numeric.

[beunderf]

Thank you verry much!! 🙂