Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i have a listbox..
Year
FY2015
MY2015
FY2014
MY2014
I WANT TO CREATE A TRIGGER TO SELECT LATEST OR MAX FIELD FROM THIS LISTBOX..
HOW CAN I CREATE AN EXPRESSION FOR SELECT IN FIELD TRIGGER TO SELECT MAX YEAR
Can I avoid *..it is showing *FY2015 is showing in current selection
Yes. Just try:
=If( Index(Concat({<Year={'*$(vMaxYear)'}>}Year), 'FY'), 'FY'&vMaxYear, 'MY'&vMaxYear)