Error for price

[Sara_Bertomeu]

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. 

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

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

¿¿¿alguna ayuda??? Gracias

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

[Sara_Bertomeu]

OHHH MY GOD, I FIND IT MYSELF!!!

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

🤣

[Sara_Bertomeu]

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

[Suvrutt_Gurjar · Accepted solution]

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

[Sara_Bertomeu]

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

Thanks Sara🙄