Expression easy for us HELP please

[Remi_BILLARS]

Hello,

I 've got a problem with an expression…I think it’s easy for us but i’m not a pro of appsheet…

Problem:

The expression (in “Results”) for the first row IN appsheet (“appformula”):
[Pears] + [Oranges] / [Markets]

For the next rows, I ALWAYS want to USE the value from cell A2 (cell’s green) but when I use the formula I wrote you above, it automatically selects A3, A4, A5 …

I would like to put:
[Pears] + [Oranges] / A2
but appsheet doesn’t work like that …
I don’t know what to put to select cell A2 …

(I specify that it is useless that I put the formula [Pears] + [Oranges] / “7” because over time I will change the value of A2)

Thanks you for help.

[Steve]

Start here:

help.appsheet.com

Expressions: The Essentials

Learn how expressions can be used in AppSheet and get started with your own.

[Remi_BILLARS]

I’ve already watched the documentation, and I haven’t found it. Also, don’t speak very good English. Please help me.

[Rene_Casana_Ama]

Just put the following formula in the D2 Cell and the results will be calculated automatically
=ARRAYFORMULA(IF(B$2:B>0;((B$2:B+C$2:C)/A2); ""))
Then, regenerate the structure in your appsheet table

You can use Google Translate or we can speak spanish if you want. Im from Honduras.

[Rene_Casana_Ama]

If you have a table called “markets”, you can count the number of markets present in that table and use it in your formula as follows:
([Pears] + [Oranges]) / COUNT(LIST(Markets[key]))

I recomend you to enclose pears and oranges with “( )” if you plan to divide the sum of them with the value of markets, otherwise, mathematically the formula will divide oranges and markets first and then will add the value of pears. example:
pears oranges / markets
5 + 100 / 10 = 15
( 5 + 100 ) / 10 = 10.5

[Remi_BILLARS]

Gracias pero me fallait una cosita, dondé puedo encontrar la llave ?

[Rene_Casana_Ama]

Bueno, yo escribí Markets[key] como ejemplo.
el campo llave es un identificador único que debes tener en tu tabla Markets, básicamente la columna con que identificas cada mercado, si tenés una tabla con 10 mercados por ejemplo y el campo llave o el campo principal con el que appsheet identifica los valores unicos es la columna titulada “Mercado” entonces tendías que poner Markets[Mercado].

De esta forma estarías indicandole a appsheet que cuente los elementos en la columna Mercado de la tabla Markets. Puedo ayudarte con tu hoja de google tambien.

En Appsheet la columna principal o “Key” está marcada de esta forma, solo debes navegar al apartado Data>Columns y seleccionar la tabla que desees.

Este es un ejemplo de mi tabla Rubros que tiene una columna llamada key pero podria tambien llamarse “llave”. Sin embargo, nombrar bien las columnas en ingles como (key, latlong, image, name, signature, email, phone) es beneficioso porque así appsheet las identifica y las marca con su tipo de dato para que no tengas que hacer mas trabajo.