I need a build a one field which display value of percent or amount so we have object A and he has 3 fields:
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))”