vendor table

hi all

i have created a flow field in the vendor table in which i would be needing the balance of the invoices with on hold column having a value of ''Y' from the vendor ledger entry table. below written is the calcformula

 

Sum("Vendor Ledger Entry"."Remaining Amt. (LCY)" WHERE (Vendor No.=FIELD(No.),On Hold=FILTER(<>'')))

 

but i am getting the below shown error

 

 

please help me.

Related
Recommended