: Greetings and happy new year. Rates are rising and I need to change the way they are calculated (currently as a percentage). However, when i do this, all the old record totals are changing too. How can I fix this?

Hi

it seems that you haven't a related PriceTable, but you have to have !

Current price must be obtained as an autoenter value from a lookup table.

currently i have one field that's a total media and then an admin that is a calculation of total media. I want to increase the admin without changing the old records.

I don't quite understand your description (what's an "admin"?), but the answer is as Daniele said: you need to auto-enter/lookup the current rate into a permanent field in the historic record. If there's a calculation, it must be based on 'local' fields only.

Gotcha Veteran.

Now, how do I differentiate between the historic and the new?

(the admin is just a service charge)

Please explain in detail how your setup worked until now.

Currently I have a field marked media in which I enter the media cost. Then, there is another field named "admin". it is an auto-entered calculation based on 3% of the media. Then, there is a Total field which is the media + admin.

Admin is raising to 4% but when I change the formula, all the old records are changing as well.

Add a new number field named AdminRate, and a new global number field named gCurrentAdminRate. Make AdminRate auto-enter the value from gCurrentAdminRate.

Show all records, and replace the value of AdminRate with 0.03. Change the field Admin to type Calculation = Media * AdminRate.

Now you can enter 0.04 into gCurrentAdminRate.

Thanks- that did the trick. Happy New Year!!! :exactly: