You need to sign in to do that
Don't have an account?
![KirstyFrance KirstyFrance](https://dfc-org-production.my.site.com/img/userprofile/default_profile_45_v2.png)
Custom Formula Field on a Custom Object
I am trying to create a custom formula field on a custom object that is a child object to the account object. The formula sets the value of the field based on a picklist value on the account object. It works fine when I try it on a custom field on the asset object, but on my custom object I get a syntax error.
When I use Account.CurrencyIsoCode to reference the currency field on the related account, I get the error "Field account does not exist".
Does anyone know if formulas on custom objects work differently to standard objects?
Try referencing this in your formula
Account__r.CurrencyIsoCode
All Answers
Try referencing this in your formula
Account__r.CurrencyIsoCode
Hi Stevemo,
Thanks for the reply. I've tried your suggestion of adding _r, this morning and it still gives the same error. The code that used for a similar filed on another object is:
IF(ISPICKVAL( Account.CurrencyIsoCode , "EUR"), "EUR", IF (ISPICKVAL( Account.CurrencyIsoCode , "SEK"), "SEK", IF(ISPICKVAL( Account.CurrencyIsoCode , "CHF"), "CHF", "GBP")))
Hi Again,
Forget that. I forgot it should be a double underscore for the __r. It is not giving an error anymore! Thanks
No problem that one always trips me up too. Glad it worked for you.
S:-/