cancel
Showing results for 
Search instead for 
Did you mean: 

Calculation in an Input Schedule

Former Member
0 Kudos

Hi,

I need to calculate certain values based on the input from the users. An example is as follows:

*WHEN POWER_ACC
*IS POW011
*REC(EXPRESSION=([POWER_ACC].[POW019]+[POWER_ACC].[POW021]+[POWER_ACC].[POW022]+
0.06*(%VALUE%*[POWER_ACC].[POW012]+[POWER_ACC].[POW014]*[POWER_ACC].[POW015]+[POWER_ACC].[POW019]))
/([POWER_ACC].[POW011]+[POWER_ACC].[POW014]),POWER_ACC="POW024")
*ENDWHEN

where all the account members included in the above formula are to be entered by the business user.

Now, in case the value of POW011 is not changed but the value of some other figure in the equation is changed, the above formula is not effected and the value of POW024 does not get refreshed.

Is there a solution to this problem that does not require repeating the check on each figure in the WHEN condition?

Thanks very much.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

I would suggest you to keep the formula as dimension logic instead of maintaining it in the script logic.

Hope this helps.

Former Member
0 Kudos

Thanks, Nilanjan,

We need to store the value of POW024 in the database since it is used for further calcultion. Would it be possible through dimension logic?

Thanks.

Former Member
0 Kudos

Hi,

Dimension logic will not store the result in the database. So, you need to use the script logic itself. However, you can modify your script to

[POWER_ACC].[#POW024] = ([POWER_ACC].[POW019]+[POWER_ACC].[POW021]+[POWER_ACC].[POW022]+
0.06*([POWER_ACC].[POW011]*[POWER_ACC].[POW012]+[POWER_ACC].[POW014]*[POWER_ACC].[POW015]
+[POWER_ACC].[POW019]))/([POWER_ACC].[POW011]+[POWER_ACC].[POW014])

Please check the brackets.

Hope this helps.

Former Member
0 Kudos

Thank you so much.

That worked.

Answers (0)