Skip to main content
Topics#FormulasFrage von Chris Becker
Chris Becker fragte in #Formulas
24. Feb. 2016, 21:22

Syntax error on formula

I'm new to Salesforce and I'm having issues with a formula to calculate fees based on number of units. The current formula is simple and works.

if(Account.Units_NA__c>0,

if(Account.Units_NA__c>50,

46000+(Account.Units_NA__c-50)*200,46000),Null)

If the units are less than 50,  it is null, if they are greater than 50, it is 46000 plus 200 for each unit over 50 - otherwise display 46000.

There is new criteria - we have multiple specialties and one of them has a different fee calculation. I tried multiple times to add that criteria and calculation but I keep getting errors - to add a ) or remove a , but I just can't make it work. I think I've butchered it so much that it doesn't bear any resemblance to what it should look like. Any help will be greatly appreciated!

if(Account.Units_NA__c>0,

if(Account.Units_NA__c>50,

46000+(Account.Units_NA__c-50)*200,46000),Null)

or(if(ispickval( Account.Specialty_Branding_NA__c ,"Best"),

If(Account.Units_NA_c> 0,

If(Account.Units_NA_c > 200,

20000+(Account.Units_NA__c-200)*5,20000)))

 
2 Antworten
  1. Deepak Gulian (Deepak Gulian)
    25. Feb. 2016, 00:32
    If(ispickval( Account.Specialty_Branding_NA__c ,"Best"),

      If(Account.Units_NA_c> 0,

      If(Account.Units_NA_c > 200,

      20000+(Account.Units_NA__c-200)*5,20000),Null)

    ,

      if(Account.Units_NA__c>0,

      if(Account.Units_NA__c>50,

      46000+(Account.Units_NA__c-50)*200,46000),Null)

    )

    Try this!
Antwort schreiben...
0/9000