The result of a multiplication is not automatically updated in the app

[Jujuy_Adventure]

Hi!
I have encountered a problem that I cannot understand.
I have created a tableX where I collect information from tableY and tableZ.
When I want to do a multiplication of these two data in my tableX, it only computes the data when, by default, it receives all the data.
If I want to change any of the multiplication variables, it does not update the result.

in this first case I have provided the data by default using"Initial value".
As can be seen, the parameters that are multiplied are “USD X Pax” * “Precio 3” and the result is correct.
but if I decide to change any of the parameters on which these values ​​are dependent, the result remains unchanged

Does anyone know how I should make the result update instantly?
Thanks

[bonameblisto]

help.appsheet.com

App Formulas and Initial Values

How you can set app formulas and initial values to dynamically assign values.

Or use Virtual column instead

[Jujuy_Adventure]

Thanks for answering!
I have also tried entering the formula as “app formula” without results. As you can see in the last image, the column “Price X Pax” is seen with transparency, which suggests that the cell cannot be edited because it is an “App Formula”.
the other parameters have been changed, but the result has not been updated

Any other idea?

[Marc_Dillon]

What is the actual expression that you are using?

[Jujuy_Adventure]

Thanks!

[bonameblisto]

Hm …
I have never had such problems with app formulas
Can you provide us screens with “price X Pas” column definition?

[Jujuy_Adventure]

[Marc_Dillon · Accepted solution]

remove all instances of [_THISROW].

[Jujuy_Adventure]

Great! Thanks!

[Jujuy_Adventure]