5 Replies Latest reply: May 16, 2012 1:02 PM by Vag Vignesh Shenoy

# Calculated fields for Measurement data type

Currently Being Moderated

Hi All,

Can anyone help in knowing if MDM can calculate Volume (of Measurement type) in meter cube(m3) by multiplying Length/Width/Height fields (all length measurement data type) in mm.

Example:

Input:

Length= 1000mm

Width= 1200mm

Height= 1000mm

Output:

Volume=1.2 m3

I tried this in Console by writing the exp as (Length*Width*height)/100000000 but is not getting any result.I also tried this by writing an assignment but it also did not work .Please need your inputs

Regards

Nitin

• ###### Re: Calculated fields for Measurement data type
Currently Being Moderated

Hi Nitin ,

I used the expression below and i got the volume as 1.2

((1000*12000*1000)/10000000000)

Please put ur expression inside brackets .

Regards,

Vag Vignesh Shenoy

• ###### Re: Calculated fields for Measurement data type
Currently Being Moderated

Hi,

Did you try this in console expression editor because i tried same but i dint get any result.

Here is the expression what i have given.Each field is of data type Measurement ( Length dimension)

I created a field Calculated Volume where i have given the above expression but not able to get the result

Niitn

• ###### Re: Calculated fields for Measurement data type
Currently Being Moderated

Hi Nitin ,

Is there any specific reason you are using Measurement Type , Cause i tried it with the normal text and it works fine .

Regards,

Vag VIgnesh Shenoy

• ###### Re: Calculated fields for Measurement data type
Currently Being Moderated

Hi ,

The only reason is to make the end users search for the records with any UOM easily.

Example :- Suppose the field length ( measurement data type ) is maintained as 25 mm.If measurement data type is maintained user can search for a record by entering 25mm or 1 inch also to have the same result.

Regards

Nitin

• ###### Re: Calculated fields for Measurement data type
Currently Being Moderated

Hi Nitin,

I tried out couple of scenarios

1) All fields are Measurement - No Result

2) 3 fields are Measurment and Calculated field is Text - No Result

3) 3 fields are Text and Caluculated field is Measureemnt - Result Obtained

3) All 4 field are Text - Result Obtained

Looks like measurement fields cannot be used for computational purposes .

Please raise a OSS and let us know what they come back with .

Regards,

Vag Vignesh Shenoy