Cantidad por item id

[Admin11a1ab]

Hola que tal, soy nuevo en esto y necesito de su ayuda

Tengo una tabla llamada Inventory, en la cual tiene 2 columnas (Item ID y Amount), tengo sus dos filas (item id y amount) virtuales y una llamada Total Stock Available , lo que quiero es que se la cantidad de cada item id aparezca, xq lo que tengo es que se suman todas las cantidades(amount) y no por item id.

[jaichith]

Where is [Quantity] in inventory table?

Without that you can't get quantity.

Your Expression is adding amount of a particular item.

[Admin11a1ab]

It is not quantity it is [amount] , what do i need to do to get every amount by item id, because it gives me the total amount and not by item id

[jaichith]

So you need total Amount of this row item .... Right?

[jaichith]

Through translation I got this.....

Hi, how are you, I'm new to this and I need your help.

I have a table called Inventory, in which it has 2 columns (Item ID and Amount), I have its two virtual rows (item id and amount) and one called Total Stock Available, what I want is for the quantity of each item id to appear , because what I have is that all the amounts are added and not by item id.

[Admin11a1ab]

yes, the translation is correct, and yes, i need the total amount by item id

[jaichith]

Expression , what you have used is right. What is the issue now?

[Admin11a1ab]

The issue is that the formula is summing all the amount of products, wha it need is 

for example:

Item ID    AMOUNT

01                5

02               3

03                1

If item id 01 has 5 products i need that in my formula throws me 5 products on total stock available

but the formula throws me 9 on total stock availbe(it means that it sums all the amounts) and when i enter on item 01 it says 9 on total stock and also in product(item id) 03, and 04

[jaichith]

Formula is right. Please check for the entries which may cause errors. 

If still this problem exists then I should look into your app. 

[Admin11a1ab]

This is the editor link

https://www.appsheet.com/Template/AppDef?appName=InventarioABB1demo-35294600-23-09-20&utm_source=sha...

[jaichith]

 

[Admin11a1ab]

AGAIN

https://www.appsheet.com/Template/AppDef?appName=InventarioABB1demo-35294600&utm_source=share_app_li...

[Admin11a1ab]

I will be so grateful, because i cant fix that since 1 month ago

[jaichith]

Now Please check, I have fixed your issue temporarily.

1.but your table has broken reference which cause this problems.

2. Expression doesn't have problem. 

3. You have computed key for the table "items" . which is not advisable. try to keep items id as key for proper functioning . 

[marcossglr]

Hola, creo que puedo ayudarte con el problema.
Primero debo empezar aclarando que las columnas físicas dentro de la base de datos y las virtuales dentro de la aplicación tienen un propósito muy específico; las físicas se usan para almacenar datos, ya bien sean estáticos o tengan tendencia a cambiarse manualmente, las virtuales se usan para poder crear datos dinámicos, que tengan que ser calculados en tiempo real. Ésta última sólo puede ser usada por la aplicación, y por tanto que es virtual, no va a aparecer en tu base de datos.

Puedo ver que tienes un pequeño desorden que te va a costar muchos dolores de cabeza en el futuro, es posible que tengamos una videoconferencia para ayudarte con ese problema?

[Admin11a1ab]

Claro, podria el dia de mañana entre 10am y 1 pm hora (UTC-6) seria una gran ayuda ya que es lo ultimo que me falta por realizar

[marcossglr]

No hay ningún problema, puedes comunicarte conmigo a mi correo electrónico.

[jaichith · Accepted solution]

Hi bro,

@Admin11a1ab , he has made 2 columns as key (instead of item id) which has lead to the creation of new computed key. So that Select () expression did not work. Now it has been fixed. 

Even though he has few broken references in table item - categories. because he don't have entries for it.  Once entries are created it will work good. 

[Admin11a1ab]

Thank you so much

[jaichith]

You're welcome

[marcossglr]

I see.
I wanted to check out the way he was setting up the data, making sure he has not any problems in the future when trying to use that system on a working process.
I always say, a solved problem is not a guarantee that other problems will come up.