Get sum of quantities for fields in one table that match with selected value of field in another table

[Anonymous]

Hello,

I have one table with Name, Quantity, and Data fields. Also, there are another table with Name field. I want to get sum of Quantities for fields where Name field in the first table matches with Name field in another table by date.

I tried Sum({<Name={$(vAntecendant)}, Date=>} Quantity), but it does not work. Here, vAntecedant is the selected Name value from the second table.

If I try Sum({<Description={"Product1"}, Date=>} Quantity) it works, but only for value "Product1". Also, when I create Text Box and display =$(vAntecendant it displays "Product1".

Could you help me to solve this problem?

[sunny_talwar]

May be try this

Sum({<Name={"$(=$(vAntecendant))"}, Date=>} Quantity)

or

Sum({<Name={"$(=vAntecendant)"}, Date=>} Quantity)