How to put multiple conditions in Filter function in ER?

(0) Share

Report

Posted on by D365FO user

465

It seems in order to use join u need to add calculated field as well.

So If i do this FILTER(CustInvoiceTrans,CustInvoiceTrans.InvoiceId = CustInvoiceJour.InvoiceId) i get no errors but what if the relation requires more fields, how to add this to the filter condition?

I need to write sth like this: FILTER(CustInvoiceTrans,CustInvoiceTrans.InvoiceId = CustInvoiceJour.InvoiceId AND CustInvoiceTrans.InvoiceDate= CustInvoiceJour.InvoiceDate) but the syntax is wrong.

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Arcadi 794 on at

Like (1)

Report

Filter(CustInvoiceTrans,AND(CustInvoiceTrans.InvoiceId = CustInvoiceJour.InvoiceId,CustInvoiceTrans.InvoiceDate= CustInvoiceJour.InvoiceDate))

Was this reply helpful? Yes No
D365FO user 465 on at

Like (0)

Report

Thank you :)

Was this reply helpful? Yes No