Sorry for my poor English, but it’s not my first language.
I have a question while building an easy app to manage my inventory: I own a farm and, when I have to add goods, there is not a problem, but I have some issue when I try to subtract them.
So everyday, to feed my cows, I need to prepare a feed ration, that is composed by many product such as cornflakes, cornmeal and flake barley, each one with different weight. One feed ration is enough for one cow. So, for example, cornflakes 4 kg, cornmeal 3 kg and flake barley 2 kg and today I have 80 cows, so I used 320 kg of cornflakes, 240 kg of cornmeal and 160 kg of flake barley and I need to subtract them from my inventory.
I set up the tables as in the photos, but I don’t know how to get to the final stage, where, by selecting my ration feed, i multiply it by the livestock in the farm.
I hope someone can help me and thanks for your time!
When I took the screenshot I didn’t modify it, but there is no difference: with number o decimal it doesn’t work anyway. About the livestock, the number of ration feed doesn’t reflects sometimes the number of animal in my farm like these days, where I need to make more ration feed with the same amount of livestock.
By the way, the problem is that I can’t even multiply for a number, because I managed to select all the data related to an id (ration feed), but the formula write down the goods and the weights in just one cell, so when I try to set up a multiply formula, it doesn’t recognize any number, just text.
I asked to the support to help me through this issue, because I can’t really figure it out, but if you have any suggestion, you’re welcome!
