2 Replies Latest reply: Jun 14, 2013 7:42 AM by Elke Corstjens RSS

    [Set Analysis] Last Month fot which value is not null

    Nicolas Aimain

      Hi all,

       

      I have several indicator for which I need to calculate through an expression the value for last month for which value is not null

       

      Monthsite ASite B
      923111
      1026127
      1121140
      12null155

       

      in the below example,I need to obtain in my graph:

       

      Site A --> 21

      Site B --> 155

       

      I manage to get the last month (12)

      But I get Site --> null

      Site B --> 155

       

      I suppose i could combinate something like max(month where len(my_value)>0) but I don't know how to do that

       

      Does anybody has an idea ?

      Thanks in advance