Apex Code Development You need to sign in to do that
Don't have an account?
tomasdd Currency and Percent fields display in one formula
I need a build a one field which display value of percent or amount so we have object A and he has 3 fields:
percent: 20%
amount:100 EUR
ABC – our formula (Currenty her type is number)
How it should work? When the percent is 0 then display amount with currency in ABC formula.
When the amount is 0 then display percents in ABC formula.
I’ve build the formula but I don’t know how can I join these fields into one formula ? Have You got any idea how may I do this ?
Type of formula is Number at the moment.
percent: 20%
amount:100 EUR
ABC – our formula (Currenty her type is number)
How it should work? When the percent is 0 then display amount with currency in ABC formula.
When the amount is 0 then display percents in ABC formula.
I’ve build the formula but I don’t know how can I join these fields into one formula ? Have You got any idea how may I do this ?
Type of formula is Number at the moment.
IF(Percent__c = 0,Amount__c, IF(Amount__c = 0,Percent__c * 100,null))”
Greetings!
I don't think its possible as the field ABC of number type and if you would like to update the field with the percentage number then you can simply write the If condiftion and add the logic.
Kindly let me know if it helps you and close your query by marking it as solved so that it can help others in the future.
Warm Regards,
Shirisha Pathuri