Skip to Content
0
Former Member
Dec 29, 2015 at 01:53 PM

How can I write ACCOUNT A="empty" in the script?

15 Views

I have the next situation and question:

1. Script calculated zero in Account A. BPC didn't write in BW zero,it made no-record in this case.

2. In my algorithm if A=0 or empty system should write a spicific value to C.

3. How can I write A="empty" in the script? Now I write zero and then use in the script comparison with zero. But i'm afraid after light optimization my script will not work correctly.

*WHEN ACCOUNT

*IS A

*REC(EXPRESSION=((%VALUE%=0) ? -1*([ACCOUNT].[B],[FLOW].[FL1],[DATASOURCE].[DSS1]) : -1*([ACCOUNT].[B],[FLOW].[FL1],[DATASOURCE].[DSS2])),ACCOUNT=C,FLOW=FL1,DATASOURCE=DSS2)

*ENDWHEN

Thank you for your answer,

Olga