Skip to main content
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Straight table values filtering

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.

Capture.JPG

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 ?

10 Replies
Not applicable
Author

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 ^^)