updating number field calculations

[emerywang]

Hi. I have a field that's a number, with an Auto-entered calculation. How can I get it to update, whenever the data that it's making the calculation on changes? I know if I changed it to a calculation field, it would update. However, it would also replace all previous values in that field, and since we used a different calculation formula in the past, that would change all our old numbers, and we can't have that.

Thanks for the help!

-Emery

[-Queue-]

What if you use a number flag field and set it with 1 for all records that shouldn't be updated? Then use a calculation of Case( flag, originalfield, yourcalculation ).

If the limit of your old way is based on date, then just use Case( datefield < changeoverdate, originalfield, yourcalculation ).

[emerywang]

Great. Thanks. BTW, would it be any different if I used an "If" function instead of Case? Never could figure out what the difference was.

Thanks.

-Emery

[-Queue-]

If you only have a true and false result, there's really no significant difference. I'm merely prefer Case over If.