filter data is null

[Aubry]

hello everybody,
I want data that is zero (no sale) in Vente OR ScnCoin

(drno is customer)

#1 data model 

#2 result ok : vente.Mt_vente=Sacancoinventes

#3 : without Vente.drno

#4 : without Scancoin.dro

it's ok it's working well

but ... now I want to filter

=> it's not working, 
the filter does not work
i don't now why

thx help me :):)

[MN2 · Accepted solution]

Hello

You have to create your Test column as a dimension in the script so that you can filter it.

[Aubry · Accepted solution]

Hello,
first, thank you for your answer,

I have two connection different : 
#1 ScanCoin

#2  Vente

I can't use "resident" function to do column 'testVenteNull'

thank you for help