Calculated fields for Measurement data type

Nitin Shanbhag May 16, 2012 8:29 AM

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

Vag Vignesh Shenoy May 16, 2012 8:59 AM (in response to Nitin Shanbhag)

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
Report Abuse

Like (0)
- Re: Calculated fields for Measurement data type
  
  Nitin Shanbhag May 16, 2012 9:51 AM (in response to Vag Vignesh Shenoy)
  
  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
  
  Report Abuse
  
  Like (0)
  - Re: Calculated fields for Measurement data type
    
    Vag Vignesh Shenoy May 16, 2012 11:08 AM (in response to Nitin Shanbhag)
    
    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
    
    Report Abuse
    
    Like (0)
    - Re: Calculated fields for Measurement data type
      
      Nitin Shanbhag May 16, 2012 11:27 AM (in response to Vag Vignesh Shenoy)
      
      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
      
      Report Abuse
      
      Like (0)
      - Re: Calculated fields for Measurement data type
        
        Vag Vignesh Shenoy May 16, 2012 1:02 PM (in response to Nitin Shanbhag)
        
        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
        
        Report Abuse
        
        Like (0)

Go to original post