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

    The Function for Linest_M

    Jiadong Chen

      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
      Jan50100-50
      Feb21020010
      Mar270300-30

       

      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)