function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
LinThawLinThaw 

How to get user currency in formula field?

Hi,

How to get user currency in formula field?
Is there anyway to get it, please let me share.
Thank in advance.

Regards,
LinThaw
Best Answer chosen by LinThaw
Raj VakatiRaj Vakati

Try any one of this two options 

1 . Create a formula with DefaultCurrencyIsoCode field.

2. If the option1 will not work .. create a custom field on the user record and update the DefaultCurrencyIsoCode into the user records with trigger .. 

SOQL 
Select Id ,DefaultCurrencyIsoCode from User

All Answers

Raj VakatiRaj Vakati
Simple .. this is the formula .. and return type is text  
$User.Currency

 

 
LinThawLinThaw
Thanks Raj,

User-added image

I tried but got error.
Any idea?

Regards,
LinThaw
Ashish DevAshish Dev
What do you mean by user currency? , Do you mean currency field ?
LinThawLinThaw
Hi Ashish,

Yes, I mean current login user's Currency Field.

User-added image

Regards,
LinThaw
Raj VakatiRaj Vakati
You could able get by Using CurrencetISOCOde filed on an object directly ... 
LinThawLinThaw
Hi Raj,

Thanks,
[CurrencyIsoCode] is vary for each record, but I want login user's currency.

Regards,
LinThaw
Raj VakatiRaj Vakati

Try any one of this two options 

1 . Create a formula with DefaultCurrencyIsoCode field.

2. If the option1 will not work .. create a custom field on the user record and update the DefaultCurrencyIsoCode into the user records with trigger .. 

SOQL 
Select Id ,DefaultCurrencyIsoCode from User
This was selected as the best answer
Raj VakatiRaj Vakati
You could refer that custom field into the formulas 
LinThawLinThaw
Hi Raj,

Option 1 is not working, maybe option 2 will work.
But i don't want to use trigger and apex.
Thanks for your reply.

Regards,
LinThaw