3 Replies Latest reply on Sep 6, 2016 3:15 AM by praveen p

# Find value of a field that is based on the Max & Min of another, at a specific level of detail

Hi, I'm struggling to find a calculation, using the example below.

Need to obtain, for each Route, the starting and ending Speed defined by the max and min of the field Seq. No. This is presented in a table.

I figured some LOD exp needs to be used but could get no further than below:

{FIXED [Route]: MAX([Seq No.])}

{FIXED [Route]: MIN([Seq No.])}

Can anyone help? Sample twbx attached.

• ###### 1. Re: Find value of a field that is based on the Max & Min of another, at a specific level of detail

End Speed

Hope this is what you wanted.

Mahfooj

1 of 1 people found this helpful
• ###### 2. Re: Find value of a field that is based on the Max & Min of another, at a specific level of detail

****, that's cool~

Thanks!

• ###### 3. Re: Find value of a field that is based on the Max & Min of another, at a specific level of detail

try this may be it helps

if [Seq No.]={fixed [Route]: MAX([Seq No.])} then [Speed]

elseif [Seq No.] = {fixed [Route]:MIN([Seq No.])}then [Speed]

end