Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2014
    Posts
    46

    Unanswered: Override mathematical field?

    Does anyone know if it is possible to manually override a formula / mathematical field? I have many instances of wanting the formula to be the "default" value, but would often like to override its value. Thanks.

  2. #2
    Join Date
    Jan 2014
    Posts
    18
    Please check the example file. You can choose between 4 options:
    1. Math formula static - you can not change the field value.
    2. Math formula dynamic - you can change the field value, but if you do so, and then will change the source fields value - result will not be updated. In other words, once you change it manually - it will never be updated if you change Nr1 or Nr2 fields. Also, as per BDB manual, this option increases DB size as it stores separate formula for each record.
    3. Simple Numeric field - calculation is redone every time you change filed Nr1 or Nr2 values. You can also change the filed value manually. Even if you change field's value manually - it will be updated once you change fields Nr1 and Nr2.
    4. Same as above. Additionally, you can enter formula manually. Select the field and press "Enter" for pop-up window to show up.
    Attached Files Attached Files

  3. #3
    Join Date
    Jan 2014
    Posts
    46
    Thanks much for your help, rimpet!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •