Skip to main content
A
Anonymous
October 25, 2016
Answered

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

  • October 25, 2016
  • 1 reply
  • 1402 views

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?

This topic has been closed for replies.
Correct answer try67

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

The problem is not solved!


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.

1 reply

try67
Community Expert
try67Community Expert
Community Expert
October 25, 2016

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

A
Anonymous
October 25, 2016

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
Community Expert
try67Community Expert
Community Expert
October 25, 2016

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...

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices