5 Replies Latest reply on Sep 13, 2016 5:57 AM by Yuriy Fal

    Max Close Date for Certain Sold Products

    Fernando Lizzaraga

      I'm looking to create a calculated field that returns the last date of sale for an specific product for each of my Accounts

       

      Ideally something like this would work :

      IF Stage="Closed" AND Product="Software" THEN MAX(Close Date) ELSE "NA"

       

      The result would be something like this table:

      Account NameLast Software Sale

      Account 1

      12/3/2015
      Account 22/1/2014
      Account 3NA
      Account 410/15/2014

       

      My data set includes Salesforce Accounts with Opportunities(with Products)

       

      Is there any trick I could use to get around the IF statement?

       

      Thanks