cancel
Showing results for 
Search instead for 
Did you mean: 

Show percentage measure as percentage display format instead of multiply with 100

Former Member
0 Kudos

Hi.

I am using an amount measure with '%' as unit. Bex Analyser shows the measure unformated as 0,05% as it is stored in the system. I do not like to change this to have a simple calculation during ETL. So I am thinking about another way instead of multiply the measure in the Query with 100 to have a correct display during reporting. Is there any setting I am missing???

We are actually using SAP BW 7.0.

Regards,

Nils

Accepted Solutions (1)

Accepted Solutions (1)

cornelia_lezoch
Active Contributor
0 Kudos

Hi nils,

if your data is 0,05 with unit % but you mean 5% then your data is wrong.

So either take away the % unit from the key figure, or correct the value.

Afterwards it will show up in the query correctly.

regards

Cornelia

Former Member
0 Kudos

Hi Cornelia,

it is like this. We get an flat file import and using the percentage value as 0,05. It is delivered from source like this and also it is easier to handle in calculations. I multiply with 100 in query mostly to avoid division of 100 in transformations or store it twice. Thats because if there is a method to format it in excel or something like this. But it seems I have to go for the solution I done in the past.

Thanks,

Nils

Loed
Active Contributor
0 Kudos

Hi,

What do you want to calculate? You can use the %A function to achieve your scenario, right?

Regards,

Loed

Former Member
0 Kudos

Nothing to calculate, I simply like to chnage the display format of a measure or attribute which seems not to be possible.

Regards,

Nils

Loed
Active Contributor
0 Kudos

Hi,

If you wanted to change the display format of 0.05 to 5% instead of multiplying it by 100 then do this..

Create a FORMULA and enter this equation..

FORMULA = PERCENTAGE_KF %A 1

You will get 5%..

PERCENTAGE_KF is the key figure for your 0.05..

Regards,

Loed

Answers (3)

Answers (3)

Loed
Active Contributor
0 Kudos

Hi,

Did you already use the %A function?

Regards,

Loed

sapna_jgurudutt
Active Contributor
0 Kudos

Hi Nils,

Can you please refer the following Document link about Percentage functions in BEx Query Designer and check whether it helps you:

http://scn.sap.com/docs/DOC-50182

Thanks & Regards,

Sapna

umashankar_poojar
Active Contributor
0 Kudos

Hi Nils,

Could you please share the data in InfoProvider, Report (Currently shown) and PSA (if there any)? along with expected output.

So that we will have clear idea about the requirement and suggest the possibilities.

Thanks,

Umashankar