on 05-16-2012 7:29 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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
User | Count |
---|---|
95 | |
11 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.