Skip to Content
0
Former Member
Nov 08, 2012 at 11:02 AM

Script to Run only when Non Zero Values

34 Views

Hi Experts,

We are have a script that updates on upload the interco dimension for example, if the user loads I_CoA 100 then I_NONE is updated for 100. Problem is that when the user loads I_NONE (incorrectly) instead of the I_CoA value, the script then overwrites I_NONE to be zero. We want to include a filter to prevent the script from executing in this situation.

Below is the script we are trying to run without success. In testing, each 2nd time we enter a zero value in I_coA the script updates I_NONE to zero incorrectly.

Any ideas as to correct the script / modify our logic?
Thanks in advance for your help.

Regards,

Eyal

//copy all the interco values entered for I_x to the I_NONE for (Loans_and_other_liabilities.xlt) - Maayan Golan Ness Sept 12

*XDIM_MEMBERSET ACCOUNT=<ALL>

*XDIM_MEMBERSET FLOW=<ALL>

*XDIM_MEMBERSET AUDITID=INPUT

*WHEN ACCOUNT.WRITEI_NONE

*IS "Y"

*WHEN AUDITID

*IS INPUT

*WHEN FLOW

*IS *

*WHEN INTERCO.Group

*IS "INTER"

*WHEN SIGNEDDATA

*IS <>0

*REC(INTERCO="I_NONE")

*ELSE

*WHEN SIGNEDDATA

*IS <>0

*WHEN INTERCO

*IS "I_NONE"

*REC(EXPRESSION=%VALUE%/1,INTERCO="I_NONE")

*ENDWHEN

*ENDWHEN

*ENDWHEN

*ENDWHEN

*ENDWHEN

*ENDWHEN

*ENDWHEN

*COMMIT