Error for price

AppSheet AppSheet Q&A
, ,
1

Hellous,

I have the same problem, I find finally a nice formula like:

SELECT(STATUS[Importe sujeto comisión],[Row ID]=[ID_ROW])

for prices, firstly I have the Type “Price” but it returns an error and change it to “List”. OK perfect I do it.

But when I saved It begin my problems… with all my tables.

All the datas with “Price”, has an error. I change it to decimal and the same.

Sara_Bertomeu_1-1657671131421.png
Sara_Bertomeu_1-1657671131421.png1320×160 17.9 KB

In the example you mention, use numbers with decimals, but I use functions. https://www.googlecloudcommunity.com/gc/AppSheet-Q-A/LIST-has-elements-of-mismatched-types-for-Price-column-reference/m-p/355641#M126132

Sara_Bertomeu_0-1657670471483.png
Sara_Bertomeu_0-1657670471483.png851×690 57.8 KB

Cambio de nuevo a decimal y ahora funciona Comision y neto. Pero no Precio Cobrado

Sara_Bertomeu_0-1657672099642.png
Sara_Bertomeu_0-1657672099642.png577×448 33.2 KB

Sara_Bertomeu_1-1657672100030.png
Sara_Bertomeu_1-1657672100030.png779×324 29.1 KB

¿¿¿alguna ayuda??? Gracias

@appsheet you make me this impossible, I know but I find the solution!!! jajajajjaja

2

OHHH MY GOD, I FIND IT MYSELF!!!

the solution DECIMAL(SELECT(STATUS[Importe sujeto comisión],[Row ID]=[ID_ROW]))

:rofl:

2 Likes
3

No it doesnt work!!! SO EASY… HELP!!!

1 Like
4

Please try wrapping the SELECT() statement with ANY()

ANY(SELECT(STATUS[Importe sujeto comisión],[Row ID]=[ID_ROW]))

The error is because SELECT() returns a list type even if the content is a single item. The column type expects a single value that we get by wrapping with ANY()

ANY() - AppSheet Help

2 Likes
5

Thanks, I think Any was for an other kind of action.

Thanks Sara :roll_eyes:

1 Like