7 Replies Latest reply on Feb 11, 2018 12:51 PM by Peter STRACHNYI

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

    Peter STRACHNYI

      Hi,

       

      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.