1 Reply Latest reply: Mar 16, 2016 5:11 AM by Felix Snijders RSS

    Linest_M, calculating the slope

    Felix Snijders

      Hi all,

       

      I need to calculate the slope of the trend per product/Department for 5 months in my script.

      This wil be used later on in a dashboard to indicate if formentioned combination has a positive or negative trend.

       

      The script I've thusfar is:

      2 Questions:

      1. is it necessary to generate all combinations of Product/department/Dates with Amnt = 0 when they do not exist

      2. Will the coding be appropriate in order to calculate the correct slope for the combinations...

       

      thx in advance!