4 Replies Latest reply on May 29, 2017 2:35 AM by Norbert Maijoor

    Filtering dates in a table-calculation

    Peter Werker

      Dear all,

      I have been working on a project where I need to calculate the percent difference between a date and a date 364 days before. Easy enough with the table-calculation "Percent of difference", which works like a charm "(ZN(SUM([Amount])) - LOOKUP(ZN(SUM([Amount])), -364)) / ABS(LOOKUP(ZN(SUM([Amount])), -364))".

      However, now I only want to show the last month in the table. And there the fun starts. As soon as I filter I am loosing the table-calculation, since I am filtering the base which is used in the calculation.

      Attached is a sample workbook, showing the table-calculation.

      Anybody has a brilliant idea how to overcome this?

       

      Thank you already, putting me on the right track here.

       

      Peter