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
Check this :
=If( Index(Concat({<Year={'*$(vMaxYear)'}>}Year), 'FY'), '*FY'&vMaxYear, '*MY'&vMaxYear)
Though I believe there would be an easier expression which is not just striking in.
try this
Sum({$<Year={'2015'}>}[Sales Amount]) - expression works,
or
(Year={$(=Max(Year))})
or u can give trigger
select infied
Filedname: date field name
String : =Max(date field)
PFA
sample
What are FY and MY stand for? Which is max year in your sample data?
Hi,
In the Trigger (May be Button Action / Text Action), Try this..
Select In Field
Field : Year
Search String : ='*'&Max(Aggr(Right(Year,4),Year))
Edit
Instead of '*', Just give 'FY'
='FY'&Max(Aggr(Right(Year,4),Year))
NONE OF THE SOLUTION WORKED. ATTACHED MY REQUIREMENT.. HELP PLZ
fy IS FULL YEAR
MY IS MID YEAR
Have you checked my attachment? If you need When the document open..
find the attachment
see this
check the OnOpen trigger