Apex Code Development You need to sign in to do that
Don't have an account?
pJabeen 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 +
IF(ISPICKVAL(CurrencyIsoCode,"CHF"),(Amount/123.65576),0)+
Please suggest a workaround
Thanks,
Jabeen
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 +
IF(ISPICKVAL(CurrencyIsoCode,"CHF"),(Amount/123.65576),0)+
Please suggest a workaround
Thanks,
Jabeen
Have you considered using advanced currency management for your use case?
https://help.salesforce.com/apex/HTViewHelpDoc?id=administration_about_advanced_currency_management.htm&language=en
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.