Currency and Percent fields display in one formula

Question

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.

IF(Percent__c = 0,Amount__c, IF(Amount__c = 0,Percent__c * 100,null))”

Shirisha Pathuri · Answer

Hi Tomas,

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

Currency and Percent fields display in one formula

Formulas

관련 학습

도움 더 받기