The Great Shift-Space bug in OBIEE (Oracle Business Intelligence Enterprise Edition)

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)

(Picture A)

This is bringing the following result (Picture B)

(Picture B)

This is the right result I am looking for. Now I decided to remove the hyphen after the shift title (Picture C)

(Picture C)

I have done the following changes (Replaced hyphen with space) in the Edit Column Formula (Picture D)

(Picture D)

What result I get is after this changes is as follows (Picture E)

(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)

(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?