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.
*REC(EXPRESSION=((%VALUE%=0) ? -1*([ACCOUNT].[B],[FLOW].[FL1],[DATASOURCE].[DSS1]) : -1*([ACCOUNT].[B],[FLOW].[FL1],[DATASOURCE].[DSS2])),ACCOUNT=C,FLOW=FL1,DATASOURCE=DSS2)
Thank you for your answer,