
4 respuestas
Hi David, Yes you could try something like this which if either Value is null it will show 0.
IF( OR(ISNULL(Value_1__c),ISNULL(Value_1__c)) , 0,
IF( ( Value_1__c * Rate_1__c) + (Value_2__c * Rate_2__c) < 125,
125,
( Value_1__c * Rate_1__c) + (Value_2__c * Rate_2__c)))
Kev