Hi, I’m trying to creat an order capture app with 2 tables:
-> orders 21_salesordersdetails.xlsx
-> orders details.
Both tables are linked by the field: “Orden_Numero” . Sales amount is loaded in the details table (field: “Monto_Facturado_ARS”), but I would like to have totals also in the orders tables.
I’m using following app formula, but the result displayed is cero…
SUM ( SELECT (21_salesordersdetails.xlsx[Monto_Facturado_ARS ],[Orden_Numero] = [_THISROW].[Orden_Numero] ))
Anybody knows what should I change in the formula?