Calculation

[Former Member]

I need to apply the % factor in calculation.

I need multiply step 1 (X) with step 2 and arrive at step 3.

Step1 = Amount is stored in 'Account1' and datasource 'DS1'.

Step2 = % increment is stored in 'Account1' and datasource 'DS2'.

Step 3= New amount to be stroed in 'Account1' and data source 'DS3'.

I need to write logic as follows: Step1 * Step2(%+100) = Step3

How would the syntex could be drafted in this scenario.

Appreciate input.

[krishna_priya1 · Accepted solution]

Syntax would be as below

*when Account
*is Account1
*when DataSrc
*is DS1
*rec(expression=%value% *( ( [Account].[Account1],[DataSrc].[DS2]) +100) , DataSrc=DS3)
*endwhen
*endwhen

[Former Member · Accepted solution]

Thanks for the input.

In Step 2: Each year the '%'for the year is entered in one month, but is applicable for all months of year.

This needs to be applied,multipl;ied to amounts of all months. How best handle this?

Appreciate input.

[Former Member · Accepted solution]

Hi,

For example, you are in 2011, and you enter the percentage in JAN month, then you can modify the script to:

*XDIM_MEMBERSET TIME = BAS(2011.TOTAL)
*XDIM_MEMBERSET ACCOUNT = ACCOUNT1

*WHEN DATASRC
*IS DS1
   *REC(EXPRESSION=%VALUE% * ( ( [TIME].[2011.JAN],[DATASRC].[DS2]) +100), DATASRC=DS3)
*ENDWHEN

Hope this helps.