2 Replies Latest reply on Oct 25, 2012 12:25 AM by Gordon Raebiger

    no NULL values in YoY calculation

    Gordon Raebiger

      Hi,

       

      tried to find the right topic but was able to find the right answer yet - so I hoe you could give me a link to the right answer or you have the right answer anyway :-).

       

      Attached a simple excample of anual figures and of course there will be no yoy % for the first - however is there a way to compute the variance for the second year but limiting the date range on a dynamically level?

       

      I hope my problem descriotion makes sense - thanks in advance anyway.

       

      Gordon