2 Replies Latest reply: Mar 14, 2018 6:39 AM by Steve Caiels RSS

    Div/0 error in summary

    LeeAnn Gill

      Hello!

       

      We have a measure in a summary where the formula for one record is 0/0 which is leaving the field blank.  We then export this file to upload into another program and it's creating an error because we can't have a blank field.  We tried to fill nulls with 0.0000 but it still doesn't export with that.

       

      Is there a way to do something similar to the iferror formula in Excel so that we can get a number in that field.

       

      Thanks!

       

      LeeAnn

        • Re: Div/0 error in summary
          Grant Perkins

          LeeAnn,

           

          Which format are you using to export to the other application?

           

          Is the other application flexible enough to accept more than one format? You have more control in text formats for example and you can multiple process to include them.

           

          That said for a single value it might be more practical to simple edit the value after export depending on the frequency of use, etc., etc.

           

          Does the target application's data ingestion process have any settings that would allow blanks to be interpreted as zero? (I assume not bit there may be functionality that has not previously been revealed to you.)

           

          Is your 0/0 calculation the result of part of the measure formula in the Summary? (I read you description and assumed it is.)

           

           

          HTH.

           

          Grant

           

          For reference here is a very old forum post for a suggested approach but it is based on fixing the challenge in the Table not the summary. Ignore the apparent posting date  - it's an import from a much older forum. And, sadly, the links will no longer work even if you manage to figure out what they are supposed to be.

           

          Exporting Null values as Zero

          • Re: Div/0 error in summary
            Steve Caiels

            Hi LeeAnn,

             

            If the nulls are generated in the table and your calculation is, for example, Value1/Value2, then change it to If(IsNull(Value1/Value2),0,Value1/Value2).

             

            If you are using a calculation if the summary itself, then I'm afraid you don't have the IF() function available.

            If you want to ignore the error lines, you can "hide" the error lines from the summary by using the Matching values on the key field.  But if you need the error lines, I'm afraid it would need a second pass in Monarch or Excel to correct the summary values.

             

            Regards,

            Steve.