function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Daniel MuirDaniel Muir 

Custom Currency Formula field within a quote

Hi All, 

I am trying to make a custom currency formula field to enter into a quote template. 

What we want it to do is: If the currency used in the quote is GBP, formula field = X price in GBP
If, however, the quote is in USD, formula field = X price in USD. 

We want to extend this to also include Euro, AUD, and Yen. 

I have tried some formulas, but I keep getting error messages. 
Srinivasan Muthu 15Srinivasan Muthu 15
Hi Daniel,

Is your Organization is enabled with Multi currency?
Usually the currency values are calculated based on the currency that is assigned in the user layout. The reason why it is working for USD is because that may be your corporate/Organization Currency. 

If you need to extend some thing in currency you may need to go for a custom solution .

Srinivasan M
Daniel MuirDaniel Muir
Hi Srinivasan, 

We do have multi currency enabled. The issue is that it will be a different figure for each currency. I am not sure if we could use an "IF" formula? So that if it was, for example, JPY, it would = xx, but if it was GBP, it would = x
Daniel MuirDaniel Muir
Here is what i tried. It, unsurprisingly, didn't work, but hopefully gives a clear picture of what we are trying.User-added image