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!
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]
ow my bad. this is the correct formula for [Cylinder VATable Sales]:
[Total Cylinder Price]/1.12
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.
User | Count |
---|---|
37 | |
26 | |
24 | |
17 | |
14 |