Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Domnic JohnsonDomnic Johnson 

Currency formula field too big

Hi,

I'm trying to add mutiple fields but its giving me a error.

Can anyone help me in reducing the size of this formula.


FM_Total_Payments__c + SM_Total_Payments__c +

Agent2_Total_Payments__c + Agent3_Total_Payments__c  +

Agent4_Total_Payments__c + Agent5_Total_Payments__c + COOP_Total_Payments__c 

Thanks, 
Alain CabonAlain Cabon
Hi,

You have a sum of formulas probably. Each type of payments is a formula and has a big size. 

You have to copy/paste here all the detailed formula for each payment. It is perhaps possible to simplify the all thing (not sure).

Regards
 
Raj VakatiRaj Vakati
Hi Domnic,

Re design your existing formulas or you can create a number or currency field and populate it by using process builder. ( Still, you can make filed as a read only from the layouts) 

Tha ks,
Raj
Domnic JohnsonDomnic Johnson
Hi Alain & Raj, 

Below is the formal example for Agent2 and the next 6 agents have the same logic.

(Each line is a indivisual field)

Net_of_HST_Sale_Price__c * First_Payment_Percentage__c (all the forumla fields are currency)

Net_of_HST_Sale_Price__c * Second_Payment_Percentage__c

Net_of_HST_Sale_Price__c * Third_Payment_Percentage__c

Net_of_HST_Sale_Price__c * FourthPayment_Percentage__c

First_Payment__c * Agent2_Percentage_Due_1__c (reference above fields)
Second_Payment__c * Agent2_Percentage_Due_2__c 
Third__c * Agent2_Percentage_Due_3__c 
Fourth_Payment__c * Agent2_Percentage_Due_4__c 

Agent2_Amount_Due_1__c + Agent2_Amount_Due_2__c + Agent2_Amount_Due_3__c + Agent2_Amount_Due_4__c
( reference above fields)

Agent2_Total_Payments__c (add up all the total dues)

FM_Total_Payments__c + SM_Total_Payments__c + Agent2_Total_Payments__c + Agent3_Total_Payments__c  + Agent4_Total_Payments__c + Agent5_Total_Payments__c + COOP_Total_Payments__c (this will be my total check field to know how much were all the agents paid in total)