Solved: Formula not computing correctly? - Page 2

JMacFeegle · 11-01-2022 01:09 AM

An app formula is not computing correctly in the app interface although the results are correct in the formula preview and I can't find out what's happening.

Columns (all in the same table):

[Price gross] | [Price net] | [Tax in %]

[Price net]=[Price gross]/(1+[Tax in %])

The expression result is correct when I test it in the expression assistant, yet in the app [Price net] is filled with the value of [Price gross]?!

EDIT: I created a virtual column that calculates the tax amount in €, and it DOES pupulate correctly, but it takes a moment (until sync of changed price is complete) - I am under the impression that virt. columns and app formulas should compute immediately? Changing the app formula for [Price net] to [Price gross]-[Tax amount in €] also leaves me with the wrong result (value of [Price gross] )!

1minManager

Logically then for 107/(1+[tax]) to equal 107, [tax] must equal 0. Or according to this, [tax] would be 0 if [tax] was blank. Is this a posibility?

https://support.google.com/appsheet/answer/11510515?hl=en

Personally I never use the 'test' part in the formula. So I can't explain why they might be different.

I'd suggest changing all the columns to simple 2 digit decimals and do it 'manually' to try and work out what it is. I can't see anything obvious but Appsheet doesn't get simple stuff like adding percentages wrong.

View solution in original post