4 Replies Latest reply on Aug 20, 2018 12:29 PM by Ken Flerlage

    Using the lookup to calculate the difference of cash flow amount between the selected date and the day before the selected date.

    Sudesh Kumar Rambaccussing

      Hi, I'm using the lookup function to calculate the difference of cash flow amount between two dates, the last date and the day before the last date

      ZN(SUM([Cash Flow Amt Cad])) - LOOKUP(ZN(SUM([Cash Flow Amt Cad])), 1).

       

      The formula is working, however I should always select the two dates.

       

      Is there any way to select only one date and the calculation is done between the selected date and the day before the selected date.