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
Solved! Go to Solution.
remove all instances of [_THISROW].
Or use Virtual column instead
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?
What is the actual expression that you are using?
Thanks!
Hm โฆ
I have never had such problems with app formulas
Can you provide us screens with โprice X Pasโ column definition?
remove all instances of [_THISROW].
Great! Thanks!
User | Count |
---|---|
36 | |
31 | |
30 | |
20 | |
17 |