How to exclude values in when end when statement in script logic .
I have a requirement like below :
ACCOUNT DIMENSION MEMBERS :
transaction data record is as below :
Now I want to post the values like below:
A 30 ( 10 + 20 i.e. A1+A2)
B 50 ( 20 + 30 i.e. B1+B2)
C 40 ( 30+10 i.e. C1+C3)
Now I want to post this data as mentioned above.
We tried to exclude the members for which "PROPERTY1" property is blank, but without success.
Please suggest the script .
Vadim Kalinin replied
In PROPERTY1 you have destination ACCOUNT ID - is it correct?
//Select Accounts with not empty PROPERTY!
*IS * //already scoped
P.S. Hope that in PROPERTY1 you have only valid base member ID's or nothing!
P.P.S The solution is for DM package, not for default.lgf!!!