Expression help

[danielnevitt]

Hi,

I have the following expression that is unfortunately not working.

Does anyone have any idea what the issue might be?

=Sum({<DTLS_PAYMENT_RECEIPT_IND={'R'},ReportDate={"$(DATE#(FirstWorkDate(today(),2)'DD/MM/YYYY')"}>}DTLS_AMOUNT)

Thanks,

Daniel

[MK_QSL · Accepted solution]

Try

SUM({<

     DTLS_PAYMENT_RECEIPT_IND={'R'},

     ReportDate = {"$(=Date(FirstWorkDate(Today(),2),'DD/MM/YYYY'))"}    

>}DTLS_AMOUNT)

[danielnevitt]

Thanks for your help