Just change the field type from calculation to number. It will keep the last calculated value.
That works perfectly -- thank you so much!
I just duplicated a calculation field to test out this idea. The duplicated field shows the calculated results in table view.
I then switched the field from calculated field to number field and all the results dissapeared.
What have I done wrong?
FMA 10.0 v3
The calculation field must have a STORED result; changing an unstored calculation to number makes the result disappear.
Thankyou for your response :)
Do you know of any way to convert a field containing an UNSTORED calculation to a permanent number field - based on its current calculated result?
You can do this with a little "juggling".
Define an extra data field.
Use replace field contents to copy the calculated values into this extra field.
Change your calculation field to a data field
Use replace field contents to copy the data from the extra field into your original field
Delete the extra field.