I know this question looks absurd.
Here is what i want to do. i have a formula field which is a number datatype. I just want to show the value as 'N/A' if the value if a field rate_type='ABC'.
IF( Rate_Type__c == 'ABC', Quantity , 'N/A')
This gives out an error
Error: Incorrect parameter type for function 'IF()'. Expected Number, received Text
Is there a way to do this?
Is there a way we can keep the formatting of a number in Text formula field?