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.