Subfield function inside set analysis

[#1]

Hi dev people,

I have been trying several hours make to work the expression: 

=Sum( {< Producto={$(=subfield(vProducto,' (',1))}>} Precio)

In vProducto is stored 'Producto1 (200)'

I have also tried:

=Sum( {< Producto={$(=subfield('Producto1 (200)',' (',1))}>} Precio)

and it does not work either.

If i try:

=Sum( {< Producto={'Producto1'}>} Precio)

it works.

It seems that the subfield expression or the variable is not well resolved. Any ideas?

Thank you!!

[Gysbert_Wassenaar · Accepted solution]

Try adding quotes around the dollar-expansion:

=Sum( {< Producto={"$(=subfield(vProducto,' (',1))"}>} Precio)

[#3]

try this

=Sum( {< Producto={'$(vProducto)'}>} Precio)

or this

=sum({<product={"$(=subfield(vProducto,'(',1))"}>}Precio)

[#4]

Gysbert, you´r my hero

It works!!,

Thank you very much.