Results 1 to 5 of 5
  1. #1
    Join Date
    Apr 2013
    Posts
    226

    Unanswered: Freezing a calculated field

    Hi,

    I'm just wondering about possible approaches where you want to calculate a field based on certain values (take as an example, calculating VAT on a sale). However, the rate of VAT may change in the future. If it does change how do you prevent existing records being recalculated while new records use the new rate?

    Cheers

    Matty

  2. #2
    Join Date
    Dec 2012
    Posts
    87
    My way:
    loading the current VAT from a setting table and store it in a variable.

    Normal Number field will be filled with this value.

    Ruleset: If field is in use, don't change the value.

  3. #3
    Join Date
    Sep 2011
    Location
    Australia
    Posts
    264
    Provided Answers: 2
    Hi Matty
    You could use a "if , else" script that changes number field only if it is blank, othrwise do nothing when some field is edited. Have not experimented with dynamic/static variation calulations but might be worth checking.
    Regards
    David

  4. #4
    Join Date
    Jul 2011
    Posts
    176
    Hi! matty
    No need to worry!
    Go to form designer.Change your formula in the calculation field.Upon closing the formula editor it will ask you if you want to apply this new formula for the earlier records. Say 'no'. You are done.

  5. #5
    Join Date
    Apr 2013
    Posts
    226
    Thanks for all the suggestions, I'll look into these.

    Matty

Posting Permissions

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