function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Julie LeszczynskiJulie 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 37sumit 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

All Answers

sumit singh 37sumit 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 LeszczynskiJulie Leszczynski
that worked - thanks so much