5 Replies Latest reply on Sep 13, 2016 5:57 AM by Yuri 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

      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?