2 Replies Latest reply on Jun 20, 2018 1:13 PM by Anand Bale

    difference from previous year for current period

    yurong.men

      Hello,

       

       

      I use window calculation to create difference from previous year for current period as above

      This is  what I have after click on edit in shelf

      ZN(SUM([Riskscore])) - LOOKUP(ZN(SUM([Riskscore])), -1)

      I have data from 2016,2017,2018, so I had 2  comparison  results for Jan to April  ,  which are 2017 compare to 2016, 2018 compare to 2017.

      My problem is for May ( previous month as of today), since I don’t have data for that month, I don’t want to compare or show the result for comparison of 2018 to 2017 , but only keep the comparison of 2017 to 2016.

       

      How do I convert this window calculation to  create a field calculation? 

       

      Thank you ,

      Yurong