2 Replies Latest reply: Oct 8, 2015 5:09 AM by Jiadong Chen RSS

    The Function for Linest_M

      I am attempting to display multiple trend lines on a straight table and Chart through the use of the linest_M function.  Currently, the correct slope calculation appears only after I have selected Month


      The below is the straight table:


      Month2015 Act2015 PlanGapLinest_M


      My question is how do I display all linest_M values for each selected "Month" at the same time??


      The trend lines is between Gap -- Month


      My expression is


      Gap = 2015 Act - 2015 Plan


      =LINEST_M( RangeSum(Above(TOTAL Sum({$<PGroup={"Parts"}, PType={"Raw"} >} NettoVK1 ), 0, RowNo(TOTAL)))


      Num(sum({$<PLGroup={"Parts"}, PLType={"Raw"} >} PAmount )*1000, '#.##'),Month)