10 Replies Latest reply on Jul 31, 2017 3:39 PM by Deepak Rai

    Get latest date data when using look up for calculating diff from prev value

    vasudha.sripuram.0

      Hi,

      I am calculating daily growth by using the below.

       

      Daily Growth=sum([TODAY])-[YESTERDAY]

      YESTERDAY=LOOKUP(attr([TODAY]), -1)

       

      I only want to show last day data and did the filter by max date=true  but it is showing null. I get

      7/31 --NULL instead of 7/31-337?

      I understand this because it will always need a before value to calculate the growth.Is there a way we can just get the data for last day which is 7/31-337?

      I believe even if we get the last 2 days (max date and max date-1) it will work as I can filter  the null for 7/30 and just show 7/31?Any ideas?

       

      Thanks!!