Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi.
I've got an issue with one table where I want to filter values that are not corresponding to my query. Or more exactly, the current query I make let appear all the values.
Here is the screenshot of the table.
In this table, the first 2 columns are dimensions (customer code and date of delivery)
the 3rd one is based on this expression :
count(DISTINCT {$<[Entete Souche]={'Facturation'}, [Entete Type]={6},[Entete Provenance]={'Avoir'},[Entete Type Avoir]={"GLOBAL"}>} CodeDocument)
and works perfectly
and the 4th is currently :
=count({1<[Entete Souche]={'Facturation'}, [Entete Type]={6},[Entete Provenance]={'Facture'}>} DISTINCT CodeDocument)
This expression is giving me all the deliveries within the database but I want only to get those correspondig to the customers that have an "Avoirs" (column 3 > 0). I've tried different solutions but none work for now.
Any idea ?
Hehe. That's so simple. You've done it Gysbert. THank you very much. (I fee a bit stupid not to have think of that ^^)