TENGO ESTA TABLA
Y NECESITO SUMAR SOLO LOS SUBTOTALES QUE ESTEN DESDE ANTES DEL REGISTRO TOTAL
TENGO ESTA FORMULA EN UNA CELDA VIRTUAL PERO NO SUMA
IF(
[PRODUCTO] = "TOTAL",
SUM(
SELECT(
detalle[subtotal],
AND(
[_ROWNUMBER] > [_THISROW_BEFORE].[_ROWNUMBER],
[_THISROW_BEFORE].[PRODUCTO] = "TOTAL"
)
)
),
[CANTIDAD]
)
AYUDA POR FAVOR
@daviddlaa wrote:
[_THISROW_BEFORE]
I think you're trying to use this for something unrelated to its actual purpose. See Access column values before and after an update - AppSheet Help.
Rows Total / sub Total - Google Cloud Community may help you.
User | Count |
---|---|
36 | |
31 | |
28 | |
23 | |
18 |