Multiply function -revenues reversal

[Former Member]

HI,

I am loading pricing data to BPC planning, i need to reverse some of the accounts ( as a part of revenue reversal) some of the accounts (val type from BI ) i could manage by using creditpostive = NO, but user want some of the accounts to be in negative signs

for example AC.BID_XX is coming as 0.10 in postive value i need to convert that into negative sign how to do that, i tried all possiblites like AC.BID_XX tried by multiplying with neatgive sign in conversion file but in vain,

Request to send your comments and suggestion for resolution

Thanks In advance

Ram

[Former Member]

Thanks

[SEdelstein]

Hi Ram -

In the ACCOUNT Conversion sheet, add a JavaScript FORMULA such as

  
EXTERNAL	INTERNAL	FORMULA
 XYZ*               *            Value* -1 
 

This will multiply any inbound account number starting with XYZ by -1.

Please see the blog on this topic at:

[/people/sheldon.edelstein/blog/2009/12/07/using-javascript-in-sap-businessobjects-planning-and-consolidation-version-for-netweaver|/people/sheldon.edelstein/blog/2009/12/07/using-javascript-in-sap-businessobjects-planning-and-consolidation-version-for-netweaver]

Regards,

Sheldon

[Former Member]

Hi Sheldon,

no luck i tried its not working i handled in BI,

Regards

Ram

[former_member190501]

Hi,

We achieved the same requirement by maintaining Transformation and conversion files as below:

Transformation file :

CREDITPOSITIVE=NO

*MAPPING

..

*CONVERSION

AMOUNT=ACCOUNT.XLS

In Conversion file (ACCOUNT.XLS)

External    Internal    Formula
1234          1234       Value*-1

hope it works...

regards,

Raju