INFORMATIONAL ** THIS INFORMATION HAS NOT BEEN VERIFIED **

How to replace "N/A" values with "0" within a report in SMI

Entry Type: Informational

Product: Sage ERP MAS 90, Sage ERP MAS 200

Application: Sage MAS Intelligence

Version Reported: 4.50

Subject: 

Values display as "N/A" instead of "0".  How to replace "N/A" values with "0" within a report in SMI

Possible Resolution:

One of two options are recommended:

1. Delete the rows containing invalid accounts and then link the spreadsheet to the report again.
2. Edit the formula for those cells in the report and use something like an IFERROR function to return a zero. 

Note:  Editing the formula would be outside the scope of our support.  For more information, see article entitled "How to access resources and help for designing Sage MAS Intelligence reports"