Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i have created Fiscal Year (e.g. 2011-2012, 2012-2013, 2013-2014,2014-2015) from Date
Year i have created from DATE is 2011,2012,2013,2014 ,
but when i am doing Max(Fiscal Year) it is giving me output 2014, but i need it should show 2014-2015 so that i can set a Trigger for max Year
It is better to use dual() for such cases in the script. Or, you can try something like:
=FirstSortedValue([Fiscal Year], -Date) as the search string for trigger.
thanks for your feedback but i want to set trigger for max year
it is not allowing me set max function on =FirstSortedValue([Fiscal Year], -Date) , giving me error
try to use maxstring(Fiscal Year)
Hi Abhay,
You need to use group by for FirstSortedValue function ..
thanks its working