Data Action Function Not Working

chetan_devrukhkar — Wed, 03 Jun 2026 16:51:14 GMT

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.

Re: Data Action Function Not Working

N1kh1l — Thu, 04 Jun 2026 05:50:43 GMT

@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.

	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

Question Re: Data Action Function Not Working in Technology Q&A

Data Action Function Not Working

Re: Data Action Function Not Working