What are the rules for using a "simplified field notation" calculation formula fillable

[liekeh50677742]

I'm making fillables and need a division formula. I use the simplified field notation twice in the fillable. In most of the fillables made till now is only one of the two division formulas working right. .

Sometimes field "total target" with division formula "field2/field1" works  and sometimes field "total competences" with division formula "field4/field3".  If I use the preview and delete some data in by example the total target fields, there is sometimes an error "the value entered does not match the format of the field "total competences", while there is no relation between these formulas.

What's going wrong?

[try67]

I just answered a very similar question here: Need help writing javascript

[liekeh50677742]

Thank you for the support. The divisor isn’t zero anytime, so this is not the question. Sometimes the formula gives the right calculation and sometimes not. Mostly one of the two in the same fillable.

I’m really getting desperate!

If you want I can sent you an example.

Greetings, Lieke

[try67]

Keep in mind that in this context empty is equivalent to zero... So if you reset your form then this error will appear.

What you're describing sounds like the result of an incorrect calculation order, though. You can set it in Form Edit mode, via Tasks - Other Tasks - Set Fields Calculation Order...

[liekeh50677742]

I’ve been looking to de Set Fields Calculation Order. All the fields are mentioned. Is that OK?

The problem is not solved!

[try67 · Accepted solution]

It's not enough that they are mentioned, you also need to make sure they are in the correct order!

In other words, if field D uses the values of fields C and B in its calculation, and field B uses the value of A then you need to make sure that the calculation order is B followed by D.