cancel
Showing results for 
Search instead for 
Did you mean: 

Calculated field

Former Member
0 Kudos

Hi

Any idea how a calculated field can be made editable or any work around.

When a calculated field is set to yes & a calculation expression is set for the field the field becomes non editable. There can be cases where the calculated field may have to be changed depending on the business case.

For eg: if a particular steel rod is ordered in meters, then due the market availability it may have to be ordered in some standard sizes & not solely as per the calculated expression

Thanks

Arvind

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Arvind,

You have to use all your business scenarios conditions in conditonal statements in calculated expression like IF(<businessfield.code>="<value>",<value to be set,IF(<businessfield.code="<value>",<value to be set>).Make your market availabilty as lookupflat with values for different sizes.Then use this field in the conditional clause above to set the value of calculated field like IF(marketavailability.code="L",100)this will set the field of calculated filed as 100 m if the avalability in market is Large or anything you want .The reason for this is calculated filed is made at console and its all cases and possible values are to be calculated there itself and once repository is up only the defined cases will be handled.Even if you are using assignments you will have to write a conditional clause in the assignment expression for the possibilities of scenarios you have in business.So the same expression can be used in calculated field also.And assignments and calculated fields both have to predefined with all the conditional statements.

I hope this helps

Thanks

Vinay

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Arvind,

a workaround may be: do not use the calculated fields (in Console) but assignment (in Data Manager). In this way you can made editable the field and write an expression. Besides, if you want to lock the field for certain users you may introduce any validation.

Hope this help you.

Vito

Former Member
0 Kudos

Thanks Vito

I would consider that as a possible workaround

michael_theis
Active Contributor
0 Kudos

Hi Arvind,

a calculated field is a calculated field. There's no way to edit this field manually in the Data Manager. The only way to change the field's value is to change the calculation expression itself.

BR Michael