Logical Function (maximum row number or record number condition with another field "Yes"
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.