8 Replies Latest reply on Mar 27, 2017 6:03 AM by Luciano Vasconcelos

    Calculate the difference between 2 different dates

    Swetha L

      Hi,

       

      I am trying to calculate the difference for 2 different dates(today and yesterday).

      I have tried using table calculation with "Difference From , Table(Down) and Previous) i.e., ZN(SUM([B])) - LOOKUP(ZN(SUM([B])), -1)

      but i am not getting correct values.

      Below is the snapshot, where i am trying to calculate the difference for 2 columns i.e., test1 and test2.

       

      Please let me know the solution for this.

       

      Thanks in Advance,

      Swetha