Standard Object(parent): Account
Standard Object Custom Field(Picklist): Term of Subscription
Custom Object (child): OCN
Custom Object Custom Field(currency): Renewal Amount
I currently have this in the formula value:
IF( OR( ISPICKVAL(Account__r.Term_of_Subscription__c, 'Monthly'), ISPICKVAL(Account__r.Term_of_Subscription__c, 'Monthly Renewal through Vendor') ), OCN__c.Renewal_Amount__c * 12, OCN__c.Renewal_Amount__c)
I am not getting the correct value in the auto population. my term of subscription field within my account object is at picklist value 'Monthly' and my Renewal Amount in the OCN object is '1'. '12' should populate the field but I am getting a value of '1'. Please help. Many Thanks
HI
IF( OR( ISPICKVAL(Account__r.Term_of_Subscription__c, 'Monthly'), ISPICKVAL(Account__r.Term_of_Subscription__c, 'Monthly Renewal through Vendor') ), OCN__c.Renewal_Amount__c * 12, OCN__c.Renewal_Amount__c ) Are you sure you are checking Account__r.Term_of_Subscription__c value and its 'Monthly', in that case, it should populate OCN__c.Renewal_Amount__c with (1*12) = 12 ? though above should work, give the below a try: IF( OR( TEXT(Account__r.Term_of_Subscription__c) = 'Monthly', TEXT(Account__r.Term_of_Subscription__c) = 'Monthly Renewal through Vendor' ), OCN__c.Renewal_Amount__c * 12, OCN__c.Renewal_Amount__c ) if still dont work experiment using just monthly once IF(TEXT(Account__r.Term_of_Subscription__c) = 'Monthly',OCN__c.Renewal_Amount__c * 12, OCN__c.Renewal_Amount__c)
