Any tips for ensuring system calculations display consistently?
I have a billing application that tracks Assets, their monthly rates, and the Rental Charges. I'm finding instances when the same field doesn't display the same value.
Example: Sub-Total field when viewing that field on an embedded report shows one number, but if I view the record directly, it shows another. The difference is nearly always a $0.01 difference. But this isn't the only field that this happens to.
So I'm seeking any tips or general good practices I should consider when creating calculation fields to ensure the data is consistent across the application. I currently have nearly 15 different calculations that a record may need to compute, store and display.
I've played around with using ROUND in some places, but that seems to cause additional problems.
Well, in most commercial applications like assets and real estate is supposed to something more technical or scientific, you were probably best rounding all your calculations off to the nearest Penny along the way because that will be what is most replicable by other users. So for example, you may have some calculations that involve percentages which caused extra decimal places, but I would just do round to the nearest penny at every stage possible