14 Replies Latest reply on Sep 28, 2017 2:07 PM by Hari Ankem

    Calculated Fields: Calculate a difference over time

    Alexander Darvishian

      I have an excel sheet detailing the visas issued per year by country and visa type. I would like to identify and visualize countries that have the highest growth or decline in visas issued since the previous year and for every X year increment (where may be every 2,3,4,etc. years).

       

      The code I have written is not computing the correct numbers:

       

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

       

      I'm not sure what I'm missing here.