1 Reply Latest reply on Mar 5, 2012 11:03 AM by philmodjunk

    Logical Function (maximum row number or record number condition with another field "Yes"

    ArifHassan

      Title

      Logical Function (maximum row number or record number condition with another field "Yes"

      Post

      I want to get maximum row number that has value "Yes". How to get that function or script. I tried if and case function; if (executed="yes", Max(line)) or Case ( executed="Yes"; max(line)). Both function gives me line 1, but actual result will be line # 2.

      Please suggest.

      Thanks

      Arif