+ Start a Discussion

Amount Converted - Custom Currency Feild

Hi All,

We have created a custom feild to capture converted value of the opportunity. Earlier we had few currencies and were able to compile with in the limit. But now, the currencies have increased and we are getting hit with this error "Formula(s) that reference this field are no longer valid: Compiled formula is too big to execute (6,101 characters). Maximum size is 5,000 characters (Related field: Formula)". 

Here is how I have done 

IF(ISPICKVAL(CurrencyIsoCode,"CAD"),(Amount/10.8761),0 +

Please suggest a workaround

Prateek Singh SengarPrateek Singh Sengar
Have you considered using advanced currency management for your use case? 

Alternate solution would be
1) Create a custom setting to store the currency conversion rate.
2) Create a trigger to populate the converted currency field based on custom setting.