As some of you might have seen in my other posts, I am having an hard time trying to make an app to aid me in the process of mixing paint (trial-and-error principle). As part of this, I have a calculated field where i compare the real amounts of paint used so far vs. the paint called for in the formula table. The formula is very simple: For each basic color, I have the app calculate a “factor = Real amount / called for amount”. If any of the factors > 1.025 then the app shoud direct me to a recalculation process, multiple the Max factor with the original formula and a second round of adding basic color painst should fall in the 1 - 1.025 range.
In the pic below, I added 200 grams in a formula that calles for 190 grams of red, giving me a correct 1.053 factor:
Now after saving and syncing it changes to:
If I click / tap on edit again, magically the 1.053 is back only to revert to 1.000 again after saving and syncing and that keeps going on forever. I checked the equations and there is no cyclical formulas involved. Every math seems perfect, but somehow the saving ruins the math.
Any idea why?
