scorecard format percentage on sap design studio

[former_member241445]

hey,everyone,

I want show percentage number in crosstable or scorecard ,spreadsheet also OK,but I false.

I can't find place to set it.Anyone knows about it?

Thanks ,

Jing

[former_member265529 · Accepted solution]

Hi Jing Zhang,

You can use the display property of crosstab to show units in data cells

You can select the place you want to display.

Thanks,

Poovarasan

[former_member241445 · Accepted solution]

Hi,Poovarasan,

I have tried you said,but it still can't realize set percentge formate,eg:

0.289 change to 28.9%

Thanks,

Jing

[former_member265529 · Accepted solution]

Hi Jing Zhang,

It only shows % symbol if your values are in percentage. It will not convert the values.

You can change keyfigure into percentage value in your query and use it in dashboard.

If it is a simple calculation on two measures, you can used Add calculation option in initial view of data source aand calculate it in design studio.

Thanks,

Poovarasan

[former_member241445 · Accepted solution]

Hi,

sap design studio can add calculation option?can you tell me where?

Thanks,

Jing

[former_member265529 · Accepted solution]

Hi,

It will be available in initial view of data source, when you right click on a measure.

The list will be different if you right click on a single measure.

Thanks,

Poovarasan

[former_member241445 · Accepted solution]

Good,about a month ago,I hava to calculate two demission,but sap employees said just wait next DS version.This is very important but always easy forget.You helped me again.

but even I add calculate in datasource,I still can't change it to percentage when I use crosstable.

you say change keyfigure into percentage value in my query,is it need realize in OLAP?

Thanks.

Jing

[former_member265529 · Accepted solution]

Hi Jing Zhang,

There must be a source to that OLAP connection an Bex Query.

You can calculate the required formula in that Bex query in query designer.

Thanks,

Poovarasan.

[former_member241445 · Accepted solution]

Hey,Poovarasan.

Maybe I known what you say.Thank you for your help.And how to create calculate is very important to me,this is additional surprise.

Good luck.

Jing.