Selecting Null Values not possible?

[fzalexanderjohn]

Good morning,

I'm trying to select null values in an App but it doesn't seem to be possible. I have two tables that are not matched 100%. So naturally some values show up as null in a straight table that contains rows from both these tables. I want to select those not matching values and for that I wanted to assign a value to the null value.

The expression for the dimension is:

=if(isNull(Buchungsdatum) or Buchungsdatum = '' or len(trim(Buchungsdatum)) = 0 or Buchungsdatum = ' ' or Buchungsdatum = '-','no Data',date(Buchungsdatum))

So every combination I could think of. I attached the app in question. It happens in the last sheet.

[agigliotti]

Hi,

is the field "Buchungsdatum" coming from a JOIN statement?

[fzalexanderjohn]

Hello Agigliotti,

the Field comes from here:

LOAD
    MATNR,
    max(date(BUDAT_MKPF)) as Buchungsdatum,
    Interval(today()-max([BUDAT_MKPF]),'D') as [Bewegung Intervall],
    floor(Interval(today()-max([BUDAT_MKPF]),'D'),30)/30 as [Bewegung Intervall Monate]

Resident PreloadMSEG
GROUP BY MATNR;

MATNR is the field that matches the values with the table that contains our product information (MARA). MARA contains more values than those of the MSEG. So it is expected that I get null values... how to select them though.

[agigliotti]

maybe you can use the below expression:

=Sum( {< MATNR = E( {< Buchungsdatum = {"*"} >} Buchungsdatum ) >} [Wert Bestand] )

it should return all MATNR with Buchungsdatum equal to NULL.

i hope it can helps.