Calculated Value Field

[jcavard]

Hi! I have a text calculation field based upon two other field. the calculation is the following

If(

Pref::Global_Language=1;

spread_imperial & " " & spread_imperial;

etalement_metric & " " & spread_metric

)

basically, it checks if the application is French or Ensligh, then display the spread length in inches/feet or cm/meter.

First, I think a calculation value can't display a combination of value, but why doesn't it update? I have another calculation field that is basically the same (based upon two different fields) and it updates as soon as the reference field value is changed. This one won't update, it always keep the same value as the first entered in the reference field. I hope I'm making myself clear. Thank you.

Jean Christophe Avard

[mr_vodka]

Do you have the calc field set as unstored?

[jcavard]

its a text field with a calculated value. where do I check for the unsorted??

[mr_vodka]

Not unsorted. Unstored under storage option. In define fields, go to your calc field, click on storage options.

[jcavard]

I don't see anything about unstored/stored in the Storage tab. I have something for the repeating field and something for the indexation (which is indexed)

[jcavard]

I see that Unstored for Calculation field, but mine is a text field with a calculated value because I have to be able to edit it.

[mr_vodka]

jcavard,

First of all I got confused because in your OP, you has said that it was a calc field.

Hi! I have a text calculation field based upon two other field. the calculation is the following

If it is a text field that has the calculated value of:

If(

Pref::Global_Language=1;

spread_imperial & " " & spread_imperial;

etalement_metric & " " & spread_metric

)

When the value of Pref::Global_Language, spread_imperial, etalement_metric, or spread_metric changes, then the value of the field should change if the checkbox for 'do not replace existing value...' is unchecked.

[jcavard]

i guess thats what happening because the field always display the first value entered... (it doesnt replace...) where is that check box? THABK YOU!!

[mr_vodka]

I apologize. you are using FM6 and dont have that option. Please post a copy of your fiel so that I might take a look.

[jcavard]

unfortunatly, its a big size file, (19mo)

[mr_vodka]

Make a copy of it, delete almost all but a few records and then post.

: