How do you calculate the inverse i.e. the 1st value assuming its not static ? For example: Consider a multi-value field with values like this 001,002, 003, 004 001,002,003,005,006 001 is the 1st value to occur in time sequence followed 002..003 in sequence. Think of it like different status changes of a ticket. If i do a mvindex(field,-1), it gives me 001 i.e. the first/earliest status to occur . What index should I specify of getting the last value in sequence as in 004 and 006 respectively.
... View more