Apex Code Development You need to sign in to do that
Don't have an account?
Daniel 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.
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.
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 .
Thanks
Srinivasan M
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