Cuenta de clientes

[Maxi]

Buen día a todos y gracias de antemano por leer la pregunta…

Estoy creando una app para llevar los trabajos realizados de fertilización con clientes, y no se cómo sumar los datos de la columna [COSTO ESTIMADO] en la tabla TRABAJOS que no estén ya cobrados (Columna [COBRADO] en valor [FALSO]) y que ese resultado se exprese en la columna [CUENTA] de la tabla “CLIENTES”.

La tabla [CLIENTES]:

La fórmula que uso en la celda [CUENTA] es:
SUM(select(TRABAJOS[COSTO ESTIMADO],AND([CLIENTE]=[_Thisrow].[CLIENTE],[COBRADO]=“FALSO”)))

y la tabla trabajos:

Saludos!!!

[Aurelien · Accepted solution]

Hi @Maxi

Your formula is almost correct, though I would bring a subtle change, please see below:

SUM(
 SELECT(TRABAJOS[COSTO ESTIMADO],
  AND(
    [CLIENTE]=[_THISROW],
    NOT([COBRADO])
   )
 )
)

Please note, that this part : [CLIENTE]=[_THISROW]
can also be expressed as [CLIENTE]=[_THISROW].[ID_CLIENTE]

For your goal, you need to use a virtual column.
You are currently using a physical column, which won’t be updated unless you edit the row.
Virtual column are always calculated on the fly, so result is always correct.

To do so:

• Remove your column from your spreadsheet.
• regenerate structure in the app editor
• add a virtual column on your table (there is a button)
  
  Then, set the name “Cuenta” and the app formula: the one above.

It should do the job, let us know if that’s OK for you.

For reference:

help.appsheet.com

Virtual Columns

Check out how you can use virtual columns to add more information to your app.

[Maxi]

Thanks You!!! This is what I need.

Thanks You so much

Maxi