cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

How to add a Constant value to an account?

former_member566000
Participant
0 Kudos
161

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


Accepted Solutions (0)

Answers (1)

Answers (1)

former_member186338
Active Contributor
0 Kudos

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/

former_member566000
Participant
0 Kudos

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

former_member186338
Active Contributor
0 Kudos

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!