Can I return two different data types in formula field based on some criteria?
Say I have a
Formula1__c field with a percent return type, and
Roll_up Summary__c field that counts all detail records wherein
Picklist__c value = 'A'.
There's a requirement that if
Roll_up Summary__c > 0, a formula field with text return type named
Result__c must be equal to A, while if
Roll_up Summary__c = 0,
Result__c must be equal to
Please bear with me, and thanks in advance.