I donโt know English very well so I hope the translator is enough.
I am doing a subtraction between the field โSaldo Cuotaโ less โValorโ and in turn I am saving the valor in the field โvalor2โ but the subtraction returns only the โSaldo Cuotaโ
IF([Cedula]=[_THISROW].[Cedula],
SPLIT([_THISROW].[Saldo Cupo]) - SPLIT([_THISROW].[Valor2]),
Ventas[Valor2])
Porque simplemente no pones en la formula dentro de saldo final ([Saldo Cupo] - [Valor])
Tienen que ser de columnas tipo number.
Your expression is all wrong. You shouldnโt be using [THISROW].
at all, and SPLIT()
is used both incorrectly and unnecessarily. And as @Ron_Adames notes, your column types are wrong.
Hola,
Si cambio el campo โSaldo Finalโ a numero me genera el siguiente error.
Column Name โSaldo Cupoโ in Schema โVentas_Schemaโ of Column Type โNumberโ has an invalid app formula โ=SELECT (Asociado[Saldo Cupo], [Cedula] = [_THISROW].[Cedula])โ. The type of the app formula โList of Priceโ does not match the column type โNumberโ.
What are you trying to accomplish? Please explain your intent using plain language, without using any AppSheet terms.
Hola @Steve,
Quiero restar โSaldo Cupoโ de โValorโ y mostrarlo en el campo โSaldo Finalโ.
Sin embargo, el valor de Saldo Cupo lo estoy trayendo de otra tabla y lo muestra de acuerdo al numero de cedula que escoja.
User | Count |
---|---|
40 | |
36 | |
34 | |
23 | |
17 |