Script Logic

[Former Member]

Hi,

My requirement is, whenever the data is saved using an input form,

1. Data needs to be multiplied by 2, (All dimensions values are same) and needs to be saved.

2. Same data needs to be saved for for the next month.

Source Data for both scenarios

Account	Entity	Category	Time	SKF	SIGNDATA
GL100100	PC1234	BUDGET	2016.01	RENTED	100

Expected Data for requirement 1.

Account	Entity	Category	Time	SKF	SIGNDATA
GL100100	PC1234	BUDGET	2016.01	RENTED	200

Expected Data for requirement 2.

Account	Entity	Category	Time	SKF	SIGNDATA
GL100100	PC1234	BUDGET	2016.02	RENTED	100

Need you help in writing the script logic for this.

-- Selva.

[former_member186338]

The script is simple, but the requirements are strange:

*FOR %T%=%TIME_SET%

*XDIM_MEMBERSET TIME=%T%

*WHEN TIME

*IS *

*REC(EXPRESSION=%VALUE%,TIME=TMVL(1,%T%)

*REC(EXPRESSION=%VALUE%*2)

*ENDWHEN

*NEXT

Vadim

[Former Member]

Hi Selva,

Is this only for one input sheet? or all input sheets for the model?

if its only one input sheet then use a hidden sheet that saves doubled up data for this month and next month.

if for the whole model then use default logic.

What is the reason to double it up?

Andy