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.
What is the "row number"? A serial number or just the position of the last record in your portal or found set?
If you define a relationship that matches on that "yes" value, the Last function can return data from the last related record.