Very interesting OBIEE (Oracle Business Intelligence Enterprise Edition) Bug. This might happen to you may be one out of 1,000,000.
I have the following report (Picture A)
This is bringing the following result (Picture B)
I have done the following changes (Replaced hyphen with space) in the Edit Column Formula (Picture D)
What result I get is after this changes is as follows (Picture E)
Look at the changes in the values!
These changes happen when I replace a “-“ with “Space”
I have done another analysis of this value in the excel (Picture F)
The space means 58-60% deduction of the original value.
I called this “The Great Shift-Space bug in OBIEE”
Could anyone help me to know why this is happening?