5 Replies Latest reply on Aug 7, 2015 11:15 AM by Rody Zakovich

    Adding Criteria for LOD Calculation

    William Chen

      I'm trying to figure out the first won deal for an account.  Doing {fixed [account name]: min(close date)} gets me the min of the close date, but I want to know the min of any won deals. 

       

      I tried doing "If stage = booked then {fixed [account name]: min(close date)}  else null" but that doesn't get me to what I need. Any ideas?

       

      Thanks in advance.