Skip to main content
답변 4개
  1. 2018년 2월 6일 오후 7: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