Cancel the formula after editing the field

[sumservis]

Hi,

how to cancel the calculation of a formula when I manually write something in the field where the result is to be displayed?


Please.

My formula -

field1 = field2 * field3;

[esforim]

Don't think you can. Only way I think of would be using an "If" statement,

For example, (written in theory, not actual formula)

If Field1 = isempty, then field2*field 3; field1=field1.

I'm not even sure if this will work as I type this. Usually I would use the "If" function to make thing blank or use a secondary formula.

[sumservis]

Hi, I figured it out ...

ifThen(
field1 == null,
field1 = field2 * 1.21;
); 

and

ifThen(
field2 == null,
field2 = field1 / 1.21;
); 

This will cause me to eventually use both fields for counting.

Respectively, always one field to calculate the difference for the other.

[esforim]

Cool, so that how you do it, using a ==null

Thank for posting solution, I will I think adopt it