So i've been creating formulas based on an excel file, now i'm having issues replicating this on studio.
So the formula somewhat goes like this :
= Field 2 * 1.1 * 1.25 * 0.5
= value1 + value2 + value3 + Field 1
so as you can see, field 1 uses the value of field 2 but since field 2 also uses field 1.
This causes unexpected behavior:
1.) The fields would show values when saving the record
2.) Since on Field 2, field 1 is still missing, it wouldn't display any value even if i already input values1, 2 and 3.
I can't seem to get this done using the formula available in studio, Hope you guys can help me on this.