Best Of

Hello Ricard,

i have also once experienced this error message and i resolved it by checking all the relationships as there were some elements of hierarchies which were not related to others and hierarchies were therefore "missing relationships".

I have normalized all trees, checked for missing relationships, corrected any missing link and resolved the item.

I have also found Troubleshoot: effect of missing relationships very interesting because it helped me preventing this in the future.

Hope this helped you

Thank you Antonio.

We've done some research and agree that this is a widespread problem that also affects Microsoft Excel. 

Microsoft Knowledgebase Article 

This link to Microsoft Support site explains the issue as follows:
"The IEEE 754 standard is a method of storing floating-point numbers in a compact way that is easy to manipulate. This standard is used by Intel coprocessors and most PC-based programs that implement floating-point math.
IEEE 754 specifies that numbers be stored in binary format to reduce storage requirements and allow the built-in binary arithmetic instructions that are available on all microprocessors to process the data in a relatively rapid fashion. However, some numbers that are simple, nonrepeating decimal numbers are converted into repeating binary numbers that cannot be stored with perfect accuracy.
For example, the number 1/10 can be represented in a decimal number system with a simple decimal:
.1
However, the same number in binary format becomes the repeating binary decimal:
.0001100011000111000111 (and so on)
This number cannot be represented in a finite amount of space. Therefore, this number is rounded down by approximately -2.78E-17 when it is stored.
If several arithmetic operations are performed to obtain a given result, these rounding errors may be cumulative."

Thanks