Skip to Content
0
Former Member
Mar 30, 2010 at 07:13 AM

Calculation in an Input Schedule

25 Views

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.