You need to sign in to do that
Don't have an account?
Chris McCoy 6
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)))
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)))
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!
All Answers
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)))
Explain it?
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!