11 Replies Latest reply on May 21, 2018 12:36 PM by Prateek Nagar

    Lookup First non null values and set it as the base value




      I have some data (see screenshot below) that displays average temperatures for each country. I would like to create a table that displays the difference for each year to base year, depending when the data first became available.


      As you can see in the picture below, for some countries, the data becomes available at a later time.

      I'm having trouble with a calculation that will look up the first non null value and then make that the base year to which all the following years will be compared to. I would like to take each year and subtract the base year from it to get the difference.


      Please help.