Why is Appsheet (the no-code app tool) not able to do the most basic math?

[CorneliusH]

Hello. Some of you might already be bored with my continnuos inquiries, but Appsheet is still dissapointing my initial enthusiasm for the "no code" programming it promises.

I have two tables in a parent-child relation. In one of them I have a "project"; in the second i have a series of adding-up numbers for that project with color names:
Row 1 5 of yellow,
row 2: 8 acummulate of red (makes 5 of yellow and 3 of red),
row 3: a new accumulate  of 10 of white (5Y, 3R, 2W).
For those of you asking, yes, it is a mix of paint. Now back in the parent table I want to make a test from the mix, and after that, substract equally from the 3 ingredients in the child table. 

It would be so logical to think that what I need is to create an action which "adds a new row to another table" (the child table) with negative numbers looping to all of the three rows  (lets say, if I put 0.5 in the parent table - 5% of the initial total - it will be -0.25 of Y, -0.15 of R  and -0.1 of W).

But Appsheet is'nt that logical or easy. No sir. In first place, I created a new virtual column in the parent table that calculates a negative % to substract from all the rows of child table. So far so good. But that is where logic and common sense stopped.  I tried to make the action adding a row to another table, but Appsheet shows me the columns of the parent table, no the child I want to act upon.

Then i got this: 

Say what??? Appsheet is not able to calcualate 0.05 * 10? 

Please, can somebode send this to someone in Mountain View? I would a "a true no-code platform, which means anyone can build rich apps and automated processes without writing a line of code" expect to be able to calculate 0.5 times 10.