The myStorman Knowledgebase is for users of Storman v8 and v9. If you use Storman v10, please use our new Support Knowledgebase. | Dismiss for today

Custom Designed Reports - Fixing NANs (#RPTCDRFN01)

Last updated:   Applies to:   In industries:   Of versions:   Special contents:
20090420 (Andy)   Pro, MultiUser, MultiSite, MultiView   Self Storage EditionMarina EditionVault Edition   7.X (and higher)   n/a
  • Article intended for experienced users (powerusers) only.

Fixing NAN's

A NAN (Not A Number) occurs when a field that is meant to contain a number, does not. NAN's often cause blanks in reports (more on reports with blank fields: #RPTBLKS01), because reports generally use calculation scripts that, obviously, are unable to calculate when a field contains something other than a number.


How do I fix NAN's?

Instructions for using StorMan's NAN-search function are provided below.

  • Note: This function is only recommend for use by advanced users & StorMan technical support agents (hence we haven't posted much information here). For assistance, please ask Technical Support. Oh, and always make a backup!
  1. Make a backup of your StorMan datafile.
  2. Select the More Reports menu, then Custom Designed Reports.
  3. Select the relevant table in which to search for NAN's using the Table selector floating window. The Transactions table is generally the one to look for NAN's in.
  4. From the Select menu, choose the Repair NAN's option (near the bottom). Use the dropdown provided to select the field that you'd like to search in (you can also select to search for All Numbers if required), and press OK to begin the search.
  5. If StorMan finds NAN's, you will then be prompted to repair them (set them to zero). If not, then no NAN's were found in the selected table using your search parameters.

If you ran this procedure because some of your reports contained blanks, please try running the reports again after running the above procedure. If the problem with your reports still persists, please contact StorMan Support.


Related articles:   Article tags:   How did we do?

fixing NANs, NANs, repair functions, report with blanks, not a number, blank reports

Did we miss a tag?
Tags improve search results. If you think this article needs more tags to help index & identify it, please suggest some using the form to the right...


If this article requires an update or needs more information, please contact

Thank you for your assistance!




Copyright 2021 Storman Software | Visit our new knowledgebase