Skip to Content
avatar image
Martin Meyer

SAP AfO show "in Mio" for scale

Aug 28, 2017 at 02:12 PM | 66 Views

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
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Varaprasad Raju Potturi
    Aug 29, 2017 at 09:19 AM

    Hi,

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

    0,, "M"

    Thanks,

    Raju

    Add comment
    10|10000 characters needed characters exceeded