Hi @Bahbus thanks for replying.
I have tested my formula in the editor and the test results are exactly what I expect them to be.
The virtual column should sum up the mutation column from all related child entries.
Up until yesterday this used to work without any problems.
My app registers transactions and I have it set up in the following way:
a parent table for transactions
In this table I have several columns but relevant for this explanation are only the regular column [Cambio:] and the virtual column [CAMBIO CALC].
[CAMBIO CALC] uses the following expression:
[Cambio:] uses an app formula which just points to [CAMBIO CALC]. I need both columns because, I use [Cambio:] to be able to see the mutations in my Google sheets and I use [CAMBIO CALC] in another part of my app where I require the sum of the mutations to be correct no matter what.
a child table for transaction entries
The relevant column in this table is [Cambio:]
What I noticed is that upon saving a child entry, and returning to the form view of the parent table, the virtual column [CAMBIO CALC] is not updated and therefore the total sum of [CAMBIO CALC] and [Cambio:] in my parents table remains 0.
Once I save the entry of the parent table, the virtual column [CAMBIO CALC] is correctly updated, but [Cambio:] of course remains 0, because it’s an app formula and not a virtual column.
The way I see it, the culprit is the virtual column that is no longer updates automatically in my form view.