Skip to main content

Hi SF Community,

I'm creating a formula to calculate an annualized or co-terminus (12 months of less) bookings amount on the opportunity but am having trouble calculating the IF statement logic, see below 

IF(Contract_Term_of_Yrs__c > 13,PEPM_Formula__c * Total_EEs_Live_Opportunity__c, , value_if_false)

I know, im missing something but for annualized amount it's (12*PEPM*Total EE live opportunity) but if Contract term is greater than 12 months, I want it to default to 12. Anyone have experience with this?

3 Antworten
  1. 6. Jan. 2019, 20:11
    Can you explain (in detail) what these 2 fields are?  

     

    What datatype are they? 

     

    What do they represent?

     

    Are either on of them Formula fields?  

     

    If they are what Formulas are they using? (and explain them in detail)
0/9000