Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!!
Try adding quotes around the dollar-expansion:
=Sum( {< Producto={"$(=subfield(vProducto,' (',1))"}>} Precio)
Try adding quotes around the dollar-expansion:
=Sum( {< Producto={"$(=subfield(vProducto,' (',1))"}>} Precio)
try this
=Sum( {< Producto={'$(vProducto)'}>} Precio)
or this
=sum({<product={"$(=subfield(vProducto,'(',1))"}>}Precio)
Gysbert, you´r my hero
It works!!,
Thank you very much.