cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Data Action Function Not Working

chetan_devrukhkar
Discoverer
0 Likes
157

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.

View Entire Topic
N1kh1l
Active Contributor

@chetan_devrukhkar 

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.

 202512202601
Account110050
Account2 100
Account3200150
Account4300200
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.

 202512202601
Account1100100
Account2 100
Account3200200
Account4300300
Account5 400

Config set to ON: Un booked range is also used with null treated as 0.

 202512202601
Account1100100
Account2 0
Account3200200
Account4300300
Account5 0

 

Hope this helps !

Nikhil