Forum Discussion
Decimal Places - rounding
Thank you.
I thought I would need to write those values to the table so that I could use them later in calculations for reports.... no? For example, if I'd like to know how many acres planted between a date range.
Either way, this is the plantings table, I set them to Double, Standard, 2. Is that not correct?
Well, you can store and re-use the calculated values. However, the same formula which calculates them in this query can also be used anywhere else you need to re-calculate the value. This is in line with good relational database design practice.
The reason we avoid storing calculated values is that hard-codes it into a field. If one of the components later gets changed, perhaps due to a correction for a data entry error, that calculated value becomes invalid and that's a bad thing.
Sometimes, we DO store a calculated value because we want to retain the "As Of This Date Calculated Value", knowing that a future calculation may be different because of changed conditions. A selling price as of the date of sale is an example of this case. Prices go up all the time, so we store the calculated price as of the date of sale so future reports accurately that As Of price for the date of the sale.
Here, there should be no such adjustments except when you correct a value entered incorrectly.
Now, the reason for the loss of decimals could be in the calculation. Can you post the ACTUAL expression, not just a screen shot?
Thanks.