Display Field by filtering on a date which equals another field date

[wafsakbp]

Hello evrybody,

I need some help to display a field on my application, it takes me more than two days now.

I manage to display the field "Titres" for a given extraction_date(key between tables), exemple for 22/07/2020   =  -0.02

I need to display the field Titres for the field "date_sem_prec_ouvr" which equals the extraction_date selected. for the example above it's = -0.04

The first table :

The second table :

I tried :     =only({<[extraction_date]={"=date_sem_prec_ouvr"}>}Titres) 

Only({$<extraction_date=$(=Only(date_jour_prec_ouvr))>}Titres)

=only({$<extraction_date= {$(date_sem_prec_ouvr)}>}Titres)

Nothing works , that's weird because when I enter =only({$<extraction_date= {"14/07/2020"}>}Titres) I have the right amount.

Thank you in advance

[jwjackso]

Try =only({<[extraction_date]={"=[extraction_date]=date_sem_prec_ouvr"}>}Titres) 

[wafsakbp]

Thank you Jwjacjso for your reply. I'm desperate right now, I tried your expressions and others but still didn't work.

only({<[extraction_date]={"=[extraction_date]=date_sem_prec_ouvr"}>}Titres)

=only({$<extraction_date={"=$extraction_date=date_sem_prec_ouvr"}>}Titres)

only({$<extraction_date={date_sem_prec_ouvr}>}Titres)

🙄

[Kushal_Chawda]

@wafsakbp  try below. 

only({<[extraction_date]=p({1}date_sem_prec_ouvr)}>}Titres)

[wafsakbp]

@Kushal_Chawda  I tried it but still didn't work. When I put this expression with the max I get the result , I don't understant what's going on on with the whole field :

=only({$<extraction_date= {"$(=Max(date_sem_prec_ouvr))"}>}Titres)

Thank you for your reply

[Kushal_Chawda · Accepted solution]

@wafsakbp  without looking at your sample data it will be hard to tell you what's going on. But I suspect that your tables are linked that is the reason it is not working. to compare field it has to be in same table. So probably you can join the table and try with your below set analysis 

only({<[extraction_date]={"=[extraction_date]=date_sem_prec_ouvr"}>}Titres)

[wafsakbp]

You're right @Kushal_Chawda