Jump to content

Convert calculation to permanent value

This topic is 6610 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I need to make a calculation only once when I import records. After that, I want to keep the calculated values and use them for Finds, so I would like to change the calculated field into an unmodifiable number field that is indexed.

Is there a simple trick to convert calculations to values? I can do it with a script, (copy the information to another field for each record), but wonder if there is a simple trick to do it faster.

Thanks for any help.

Link to comment
Share on other sites

Neither of these worked for me, but I think it's because my calculation references related fields.

If(RelatedTableOccurrence:total > (thistable)sum; 1; 0)

The 1 goes away with changing to number, or changing to number with auto-enter calculation using do not change values. I guess this is a little much to expect the program to do.

Link to comment
Share on other sites

In playing around with this, I think I discovered something.

The change to number from calc doesn't seem to work when you use a self join, and the calculation uses a field from the "child" table occurrence.

It does seem to work when you use only a field from the parent table in the calculation.

But here the weird part. If I have a calc, say the calcfield = numberfield / 3. If I have a second table occurrence already set up, and then I change calcfield to a number from a calc, I will get <Index if i place the field from the child table occurrence.

However, if i change the field to number, and then create the 2nd table occurrence, i can get the number to properly appear in the child table occurrence field.

So the logic of the program seems to require a specific sequence of events, or to say it another way the relationship at the time the child table is created seem to define function, and later changes to the parent table aren't recognized? Or perhaps there's a way to force a readjustment in the child.

It may all be different if it isn't a self-join. Anyway, I hope my rambling helps someone.

Link to comment
Share on other sites

This topic is 6610 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.