Im using File Math to sum several files together but the resulting file contains blanks in the input arrays. What could be causing this?
Most likely there are blanks in at least one of the source files. When performing File Math (or Table Math), any blank cell included in the calculations will result in a corresponding blank cell in the resulting array. The Blanks to Zeros utility, available from your computer’s Start menu under Programs | ReservePro, converts all blank cells to zeros in selected ReservePro files so that these two operations will not result in blank cells. The utility will not affect arrays that do not contain any data; it will only convert blank cells in arrays with data in at least one cell. It must be executed prior to using File Math or Table Math.
Related Questions
- The Summary of Losses and Reserves report from one of my files is comprised of different columns than the same report from another file. Whats causing this variation?
- File Size - How big of files can I download? Can I download movies and TV shows without causing a problem for the community?
- How do I create 2 PDF files for each input file, each with a different configuration?