I have been asked to create a field on Opportunity that will show the value of the Amount field but taking into account the Probaility value. So, if the Amount field was GBP 100,000 and the Probability field was 80%, then this new field would show GBP 80,000.
However this does not seem to be possible in a formula field (I naively thought this would be simple). When attempting to perform any maths on the Amount field all that is returned is 0.
I can see why, the currency field is not a number, it includes the string of the currency being used, formatting and exchange rates, so doing maths on this is not as simple as it first seems. But surely this requirement cannot be that uncommon, it must be possible... right?
Any help greatly appreciated. I can't face telling the sales director I can't do maths on currencies :/
We are using managed currencies if that affects the answers. My code so far is as so:
(Total_Value_Retail__c + Total_Value_Rental__c) * (Value(Text(Probability)) / 100)