Skip to main content
Topics#Data ManagementDomanda di Jasmeet Randhawa
Jasmeet Randhawa ha fatto una domanda in #Data Management
16 set 2016, 17:44

Divide by zero issue.

Hello Commnity,

 

How can I fix the following formula to not show #.Error! when denominator is 0?

 

field1__c/Field2__c

 

thank you for any help in advance.
5 risposte
  1. Mayank Srivastava (eVerge Group)
    16 set 2016, 17:47

    Then this:

    IF( 
      OR(
           ISBLANK(Field2__c), 
           Field2__c = 0
        ), 1 ,
           field1__c/ Field2__c
    )
Scrivi una risposta...
0/9000