AnsweredAssumed Answered

Auto Calculated Fields

Question asked by mike.goss@citta.co.uk on Oct 27, 2016
Latest reply on Oct 27, 2016 by philmodjunk

When are they calculated?

 

I have an Invoice Database where there is a Goods Value, Discount %, Discounted Amount, Discounted Goods Value, Carriage, Net Value, Vat Rate, Vat Amount and Gross Value. Many of these fields are set up to auto-calculate from the others. For instance Net Value is Discounted Goods Value + Carriage, etc.

Now I have seen situations where the non-calculated fields have data in them, but he calculated fields dependent upon them don't. Only to find the calculated fields are set correctly when I look at them later.

 

When, precisely, are the values of calculated fields, calculated?

 

If I can't get to the bottom of this I am going to have redefine the fields and add script steps to calculate them so I can be sure they are set when they need to be.

 

Mike

Outcomes