Script logic

[dipalpatel]

Hello

I have below script logic in one of the models. This script applies to only Accounts with attribute of USER2ACT with value of CONVERT. It does work fine. But the issue is even if i change data for any other accounts in BPC, this script runs and changes the number for accounts in Select statement below.

How can i run this script only when i change numbers for those specific accounts?

*SELECT(%OVERACC1%, "[ID]", "ACCOUNT", "[USER2ACT]='CONVERT'")

*XDIM_MEMBERSET RPTCURRENCY = LC

*XDIM_MEMBERSET ACCOUNT =%OVERACC1%

*WHEN ACCOUNT

*IS %OVERACC1%

*REC(EXPRESSION= ( %VALUE% /2.20462)

*ENDWHEN

*COMMIT

Thanks

[former_member186338]

Bad idea to have:

AccountValue=AccountValue/2.20462

Use another AUDITTRAIL to store result of calculation.

[dipalpatel]

Thanks Vadim for the response and suggestion.