AnsweredAssumed Answered

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

Question asked by ArifHassan on Mar 5, 2012
Latest reply on Mar 5, 2012 by philmodjunk

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

 

 

 

Outcomes