Fill data/zero instead of NULL with a data action - sap analytics cloud

[Deb_]

Hello

I want to fill a number (usually 0 or 1, in this case zero) in a range of unbooked data.
the script I wrote is'

IF RESULTLOOKUP([d/ACCOUNT] = "QUANTITY")=NULL
THEN
DATA([d/ACCOUNT] ="QUANTITY") = 0 
ENDIF

I have few IFs and Memberset that focus my data action of course, but this part of the formula just don't work.
I tried with "1" it didn't work either

is it possible to fill with a data action a NULL range???

thanks

Deb

[hartmut_koerner]

Hi Deb,

for me it worked with a "1", but not with the "0".

Best regards
Hartmut

[Deb_]

but I need a zero..... in this case
can you help?

[hartmut_koerner]

Hi Deb,

at least with a workaround: For me, the following worked:

IF RESULTLOOKUP([d/ACCOUNT]="QUANTITY")= NULL THEN
  DATA([d/ACCOUNT]="QUANTITY") = 1 
  DATA([d/ACCOUNT]="QUANTITY") = RESULTLOOKUP([d/ACCOUNT]="QUANTITY") * 0 
ENDIF

Best regards
Hartmut

[Deb_]

I'm gonna try and come back to you - thanks!

[hartmut_koerner]

Hi Deb,

in the meantime I have find out that this works as designed. Assigning 0 only works for booked data, not for unbooked.
There is a special handling for "0" in order to prevent the unnecessary creation of 0-records.

A simpler workaround might be the following, please try it out:

INTEGER @ZeroVariable
@ZeroVariable=0

IF RESULTLOOKUP([d/ACCOUNT]="QUANTITY")= NULL THEN
  DATA([d/ACCOUNT]="QUANTITY") = @ZeroVariable 
ENDIF

Best regards
Hartmut

[Deb_]

Hey Hartmut
I've tried it on one item only, the DA works very slow, but it seems to work
thank you very much!!!!
you saved me 🙂
I'm taking it from here

have a nice day!

[former_member341535]

Hi,

Try

DATA([d/ACCOUNT] ="QUANTITY") = 1-1

For some reason we can't book 0 directly...

[JefB]

Might be more performant to use

MEMBERSET [d/ACCOUNT]="QUANTITY"
DATA.APPEND()=.00

Or perhaps you can set this config keyword to let RESULTLOOKUP() statements return zero values.

CONFIG.GENERATE_UNBOOKED_DATA = ON