Skip to main content
4 件の回答
  1. 2018年2月6日 19:13
    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

0/9000