4 Replies Latest reply on May 21, 2020 1:53 PM by Dianna Gibbs

    Error - Error message is [<<Expression Error>> [/]: divisor is zero

    Dianna Gibbs Seasoned Veteran

      Is there a way to ignore this error and load the other data?  We know our source data is not the best but it's skipping these rows - I have about 30 rows causing the issue with about 35 variables trying to divide.  Some values are 0, some are null.  Do I have to do an iff variable for each one to modify to 0 if null or is there an easier fix?

       

      Any suggestions appreciated!

       

      Thanks.