• #31498
    Salesforce | Elizabeth Elizabeth #97
    Forcetalks

    Formula Field on Opportunity

    Hi all- been a while since I constructed one of these and wanted to get some help- On the opp object, looking to create a formula field based on 2 fields- Amount & License_Period_months__c ( A number field type).

    Here’s what I’m trying to accomplish:

    If

    License_Period_months__c = 12,  Amount

    If

    License_Period_months__c = 24,  Amount * 2 * .15

    If

    License_Period_months__c = 36,  Amount * 3 * .30

     

    I’m screwing up the IF statements here and getting errors. Can I get some advice on how you’d construct this to get the right amount? And would the field formula type be Currency? thanks!

     

    #31585
    Forcetalks

    Hello Elizabeth,

    My solution is:-

    IF(License_Period_months__c = 12, Amount, IF(License_Period_months__c = 24, Amount * 2 * .15, IF(License_Period_months__c = 36, Amount * 3 * .30, 0) ) )

    Thanks.

Viewing 2 posts - 1 through 2 (of 2 total)

Please to reply to this topic.

CONTACT US

We're not around right now. But you can send us an email and we'll get back to you, asap.

Sending

About Us

Forcetalks is a Salesforce collaboration platform for coders & developers, geeks & nerds, consultants & business heads, admins & architects, managers & marketers and of course the business owners. A community where you can learn from, where you can contribute to. For you. For Salesforce. Read More...

Copyright 2018 Forcetalks. All Right Reserved.

Log in with your credentials

or    

Forgot your details?