Showing results for 
Search instead for 
Did you mean: 

Amount is displayed as '-500.00 ERROR' instead of '-500.00' in BEx Report ?

Former Member
0 Kudos

Hi all,

It is displayed as '-500.00 ERROR' in the report, but it should display '-500.00' (Negative 500.00).

In R/3: Field Name - KBETR of KONP table

Currency Key KONWA (Rate unit (currency or percentage))

In BW: Currency Key InfoObject: 0COND_CURR (Rate unit (currency or percentage))

I could see this amount as '500.00-' in KONP Table, ODS and InfoCube.

I have verified this Amount field in the Update Rules and it has the 'Unit of the Source Key Figure' as '0COND_CURR (Rate unit (currency or percentage))' which is correct.

How can I eliminate this 'ERROR' after the Amount, PLEASE ?



Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

It has been fixed after populating the Currency field (KONWA of KONP) in Extractor.


Active Contributor
0 Kudos

Hide your original Key Fig Column and create a new Formula Column . In that use Data Function NoDim() in the formula.........

e.g. NoDim(K.F)

Hope this solves your problem