Skip to Content
0

SAP AfO show "in Mio" for scale

Aug 28, 2017 at 02:12 PM

58

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Varaprasad Raju Potturi 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

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

0

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