4 Replies Latest reply on Jul 18, 2018 3:05 AM by Mahfooj Khan

    Finding Maximum of a Date column based on another column revenue which is not null

    Anthony Raj

      Hi,

       

      Thanks for trying to help me.

       

      I have two columns, first is date column which contains the list of dates of the entire financial year, the second column contains the revenue of each day. The revenue for future dates will be blank. Hence I need to find out the maximum of date for which the revenue is not null. Can you give me a calculated field formula to find this.

       

      Thanks.

      Anthony

      150

      DateRevenue
      01/01/2018100
      02/01/2018
      03/01/2018

       

      I need to pull value 02/01/2018 which is the latest date that contains revenue.