why would a formula revert after saving?

[CorneliusH]

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?

[JMPeterson]

Can you share what you have in the formula field please? I don't have any great insight, but hoping the physical formula might produce a lightbulb.

[CorneliusH]

This is the Max formula:

MAX(LIST([%BLANCO],[%NEGRO],[%ACR],[%ROX]))

Basically give me the highest of 4 numbers which come from 4 virtual columns. The formula for each of them:

[BLANCO]/LOOKUP([MIX],"FORMULAS","COLOR MIX","BLANCO")

"Blanco" is the amount of White paint. Data I put in manually. This number is compared agaInst the recipe in the formula table.

[AleksiAlkio · Accepted solution]

Use 1.0*[Blanco]/...