Skip to main content

I want to create a simple table calculation that compares values directly next to one another without crossing into the next month.  For example, in the image below, I'd like to calculate % change from 

Feb 2009 to 2010, from Feb 2010 to 2011, and so on, but I do not want to calculate Jan 2012 to Feb 2009 just because they are next to one another.  Is there a way to add an "IF" clause to prevent that calculation?

 

I've included the .twbx file I used to generate the screenshot.

 

Compare to previous year within section

5 answers
  1. Apr 5, 2019, 4:46 PM

    Hi Jeremy

     

    Please find the workbook attached with a solution.

     

    The table calc looks like this:

     

    Hi Jeremy Please find the workbook attached with a solution. The table calc looks like this: I hope this helps, if does, can you please mark it as correct answer?

    I hope this helps, if does, can you please mark it as correct answer?

     

    Cheers

    Rodrigo

0/9000