Bex report showing blank space after removing the -Adjust formatting after refreshing.

[dushmanta_das8970]

Bex report showing blank space after removing the -Adjust formatting after refreshing from Query designer for remove comma.

For removing the comma from Bex report, I deselect the adjust formatting after refreshing in query designer. There is no separator but there is a "blank" space in the figures. How to remove the space.

Example -

Before uncheck - Adjust formatting after refreshing - 1,380,720

After removed adjust formatting after refreshing - 1 380 720
It should display - 1380720

Please suggest is there any setting in Query designer, CP or CV for all key figures.

[dushmanta_das8970]

Not found any standard setting to remove the space in Query design.

So converted all Key figures to characteristics since they will not be used for aggregation.

Created calculated columns for require key figure in CV.