Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I want to display the max year in the list box. I tried to use the create a variable with expression as Max(year) and used that variable in the list box it is displaying the Year correctly but not able to select the year from the list box. Also i have tried to use the max(year) in the list box but the same problem i am not able to do the selection.
It would be great if somebody helps me to fix this issue.
A list box is always of list of all values in a field. However, if you create a statistics box, the maximum value of a field is one ov the things you can show. So, create a statisticts box and remove the other lines (Sum, Avg, Min, etc)
Hello,
For another option, you can also try to add the below script
MaxYear:
LOAD Max(Year) as Year, //linked here to MasterCalendar, to be linked to your desired data table
Max(Year) as MaxYear //this is the list box field that can be selected
Resident MasterCalendar; //or your data table where you create a Year field
Hope this helps too.