Skip to Content
-1

How to add a Constant value to an account?

May 07 at 05:42 AM

23

avatar image

Hi,

In SAP BPC 10.0 NW, when I am trying to add a constant value to an account, I am not able to get the desired result.

Example:

Acccount: 25 = Account30 + 1193588

if account 30 = -6475089

After logic the account should be:

A25 = -5281501

I have tried the below logic but it is not giving the correct result

[ACCOUNT].[#25] = [ACCOUNT].[30]+1193588


Thanks,

Samhita


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

1 Answer

Vadim Kalinin May 07 at 06:25 AM
0

Never use MDX calculations!

Use WHEN/ENDWHEN. Please describe the required logic based on

https://blogs.sap.com/2014/01/31/how-to-ask-questions-about-script-logic-issues/

Show 2 Share
10 |10000 characters needed characters left characters exceeded

Hi,

I have even tried the below logic but it is not giving the desired result,

*WHEN ACCOUNT

*IS 30

*REC(EXPRESSION=%VALUE%+1193588, ACCOUNT=25)

*ENDWHEN

*COMMIT

Could you please help me out with adding a constant value to any account?

Thanks,

Samhita

0
Samhita Vankayalapati

There are NO issues with adding constant value to the account! You are doing something wrong!

But you don't want to prepare your question in line with https://blogs.sap.com/2014/01/31/how-to-ask-questions-about-script-logic-issues

Then I am unable to help you!

0