It does not allow me to do a subtraction

[David_Anibal_Va]

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])

[Ron_Adames]

Hola @David_Anibal_Vasquez

Porque simplemente no pones en la formula dentro de saldo final ([Saldo Cupo] - [Valor])

Tienen que ser de columnas tipo number.

[Steve]

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.

[David_Anibal_Va]

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’.

[Steve]

What are you trying to accomplish? Please explain your intent using plain language, without using any AppSheet terms.

[David_Anibal_Va]

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.