2 Replies Latest reply on Jan 17, 2019 7:19 PM by Shinichiro Murakami

    Difference over two year running average calculation

    Zachary Smith

      I'm really struggling trying to calculate the following situation

       

      EX

       

      Company ID     FY 2016      FY2017     FY2018

      11111                    24               0               50

      11112                    10               12               9

      11113                    0                    20               18

       

      Once I have the calculated field for average then I want the difference for FY2018

       

      Company ID     TWO YR AVG      FY2018

      11111                    12                         38

      11112                    11                         -2

      11113                    10                         8

       

      This is what I'm trying to accomplish.

       

      Thank you very much