2 weeks ago
Data action Function :- CONFIG.GENERATE_UNBOOKED_DATA = {ON | OFF} is not working as expected . It is not converting Null value to 0 in the code due to which our logic doesnt work.
Request clarification before answering.
You have not provided your code example to determine if its working or not. Please note This configuration does not imply that all nulls or un booked intersection will be made 0. Its used in the context of source and target range to determine if the source un booked values are used while assigning target.
For example.
Existing Data.
| 202512 | 202601 | |
| Account1 | 100 | 50 |
| Account2 | 100 | |
| Account3 | 200 | 150 |
| Account4 | 300 | 200 |
| Account5 | 400 |
If we copy data using below code
DATA("[d/date]="202601")=RESULTLOOKUP("[d/date]="202512")
Config set to OFF : Only booked source range is assigned.
| 202512 | 202601 | |
| Account1 | 100 | 100 |
| Account2 | 100 | |
| Account3 | 200 | 200 |
| Account4 | 300 | 300 |
| Account5 | 400 |
Config set to ON: Un booked range is also used with null treated as 0.
| 202512 | 202601 | |
| Account1 | 100 | 100 |
| Account2 | 0 | |
| Account3 | 200 | 200 |
| Account4 | 300 | 300 |
| Account5 | 0 |
Hope this helps !
Nikhil
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
| User | Count |
|---|---|
| 7 | |
| 6 | |
| 5 | |
| 4 | |
| 4 | |
| 4 | |
| 3 | |
| 2 | |
| 2 | |
| 2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.