Invert the values of Query

[hodrv]

Hello all,

I have a BEx report based on Analysis for Office Excel. I want to inverse the value sign based on Dimension(Characteristics). For e.g. If it is (-1) it should be (1), if it is (1) it should be (-1).

Please tell me the appropriate solution at BEx level or VBA Macros Level.

Regards

Parichay Gupta

[gregor_dieckmann · Accepted solution]

Hi,

change the sign based on master data attribute values is a standard query feature, check the following blog where this feature is used in planning:

https://blogs.sap.com/2017/01/19/from-bpc-standard-to-bpc-embedded-reverse-sign-for-account-type-wit...

Regards,

Gregor