Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
To save space on screen I would like to abbreviate Apr, May, Jun. Jul etc as A. M, J, J when I try to put these into a list box they naturally are condensed to their distinct values..... A,D,F,J,M,N,O,S.... is there a way to get this so the ListBox reads A,M,J,J,A,S,O,N,D,J,F ??
Many thanks,
Phil
load or directly in the list box...
Try this
Dual(Letter, MonthNum)
Hi,
Is this in the load script?
load or directly in the list box...
Thanks! One Last thing, How can I get it to Sort in Fin Month order?
What is your Fin Month Order?
May be you can just use Pick Match function. Let say your Month Start with April
Pick(MonthNum, 10, 11, 12, 1, 2, 3, 4, 5, 6, 7, 8, 9)
Sort Is working thanks! Is there any to keep the Month static in the list box when it is selected rather than it moving to the top?:
If you used a sort expression, then wrap it around with Only({1} .....)