Skip to Content
0

SAP AfO show "in Mio" for scale

Aug 28, 2017 at 02:12 PM

58

avatar image
Martin Meyer

Hi there,

I am scaling my key figures by the millions in Afo to shorten the width. Sadly when I show the scale it says 1.000.000 which does not help my intention to make it smaller.

I am wondering if I can replace this (in Query, in AfO, maybe with VBA?) so it shows "Mio" or "in Mio" instead of the number.

Thanks in advance

2017-08-28-16h11-08.png (1.0 kB)
2017-08-28-16h11-08.png (1.0 kB)
SAP Analysis for Microsoft Office
scale | millions
Answers Answers and Comments
10 |10000 characters needed characters left characters exceeded
▼ Viewable by all users
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Sort by:
avatar image
Varaprasad Raju Potturi Answered Aug 29, 2017 at 09:19 AM
0

Hi,

You can try Format Cells under Analysis -->Format with custom format

0,, "M"

Thanks,

Raju


screen-dump.png (7.0 kB)
Show 2 Share
10 |10000 characters needed characters left characters exceeded
▼ Viewable by all users
Martin Meyer
Aug 29, 2017 at 01:04 PM

This doesn't work cause the Button is disabled when I click in the cell with the scale.

0
Varaprasad Raju Potturi
Martin Meyer
Aug 30, 2017 at 03:00 AM

Hi,

It will enable if you place the cursor on Key figure ( in your case its Value).

Since you are going to do format cells you can remove scaling.

Thanks,

Raju

0
Comment