Div/0 error in summary

LeeAnn_20907
LeeAnn_20907 Altair Community Member
edited February 2018 in Community Q&A

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

Tagged:

Answers

  • Altair Forum User
    Altair Forum User
    Altair Employee
    edited February 2018

    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

  • Altair Forum User
    Altair Forum User
    Altair Employee
    edited March 2018

    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.

Categories