You need to sign in to do that
Don't have an account?

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
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
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
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