title: formula field to calculate override field
body: <p>Trying to create a formula field so it checks if there is an override field (currency), if there isn't an override field, it should calculate the value based on two other fields (i.e. contract length and monthly rev). </p>
  
  <p>what am i missing in this below formula</p>
  
  <p>BLANKVALUE(ACV_Override__c, Monthly_Revenue__c * MIN( Contract_Length__c ,12))</p>
  
  <p>it is accepting the formula but when i look at the opportunity reports, the formula field only picks up the over ride amount (when there is one) , if not, then it leaves it blank instead of calculating the 'Monthly_Revenue__c * MIN( Contract_Length__c ,12'</p>
  
  <p>Thanks</p>