IF formula not updating as expected, needs some sort of trigger before getting expected value

[Jasper_Daanoy]

Hi everyone,

I have encountered a problem while calling a calculated column [Cylinder VATable Sales] and displaying it on this column [LC11]. Both of these columns are inside my table "tbl_orderdetails". 

Column [Cylinder VATable Sales] have this formula:

[Cylinder VATable Sales]*0.12

While Column [LC11] have this formula:

IF([ProductID] = 2, [_THISROW].[Cylinder VATable Sales],0)

Now the problem is when i assign 2 on [ProductID], the value on [LC11] remains 0. But when i assign other [ProductID] like 3 and assigned it back to 2, that's the time the expected value appears on [LC11]. I have no idea why is this happening. Any ideas? Thanks in advance!

[Rafael_ANEIC-PY]

Hello @Jasper_Daanoy, what IS the expected value on [LC11] ? 

It isn't quite clear to me how or why you're using the expression [Cylinder VATable Sales]*0.12 on the same column that is on the expression, which is [Cylinder VATable Sales]

[Jasper_Daanoy]

ow my bad. this is the correct formula for [Cylinder VATable Sales]:

[Total Cylinder Price]/1.12

[Steve]

If LC11 is a column in your spreadsheet (or database), its value will not be recomputed until the row is opened in a form view or is changed by an action. That's just how AppSheet works.

[SkrOYC]

App Formulas and Initial Values | AppSheet Help Center