ShowAll Questionssorted byDate Posted
Julie Leszczynski

# Formula Needed

I need a formula that will calculate the difference between Projected Fees and Actual pro-rated Fees but does not include our first year accounts. I have tried the following:
IF (First_Year_Account__c) = "false"
Pro_Rata_Agreement_Fee__c  -  Projected_FY_Fee__c

I get the following message: Error: Syntax error. Extra Pro_Rata_Agreement_Fee__c

The First Year Account field is a check box that is only checked during the first annual term of the account.
Any help would be appreciate.
Julie J
Best Answer chosen by Julie Leszczynski
sumit singh 37
if(First_Year_Account__c=="false",Pro_Rata_Agreement_Fee__c  -  Projected_FY_Fee__c,0)

use this formula,
First_Year_Account__c is a Text then use above , if Boolean

if(First_Year_Account__c==false,Pro_Rata_Agreement_Fee__c  -  Projected_FY_Fee__c,0)

http://resources.docs.salesforce.com/200/9/en-us/sfdc/pdf/salesforce_formulas_cheatsheet.pdf

sumit singh 37
if(First_Year_Account__c=="false",Pro_Rata_Agreement_Fee__c  -  Projected_FY_Fee__c,0)

use this formula,
First_Year_Account__c is a Text then use above , if Boolean

if(First_Year_Account__c==false,Pro_Rata_Agreement_Fee__c  -  Projected_FY_Fee__c,0)

http://resources.docs.salesforce.com/200/9/en-us/sfdc/pdf/salesforce_formulas_cheatsheet.pdf
This was selected as the best answer
Julie Leszczynski
that worked - thanks so much