2 of 2 people found this helpful
You may need to tell us more about the file structure (fields and relationships).
But IMHO 99.99999% of the time it is a safe bet that you have overlooked a subtle data error.
Key fields that aren't quite correct, maybe they have an extra space or mis-typed value.
Fields that should be number fields that are instead defined as text fields.
Fields that should be date fields that are instead defined as text fields.
Calculation expressions that quote numeric values, thus turning them into text.
One of the interesting tools to use when researching this kind of problem is to use Insert from Index.
The safest way to do this is to enter find mode; click into a field; then do command-I.
See attached example.
I fully endorse Bruce's recommendation of using Insert from Index as a convenient way to spot dodgy data—and his observation that that may well be the source of the oddities you've observed.
You could also try to save a compacted copy of the file, which process I believe resets field indexes (please correct me if I'm wrong anybody).
The file is not corrupt. I figured out that there were duplicates which were causing the NOI and Distributions to be wrong. Thanks for both of your responses.