Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
I am using text box to show curremt selection:
='>> ' &
Year
& ' > '&concat(DISTINCT if(len(Quarter)>1,Quarter), ', ')
& ' > '&concat(date([DB Date]), ', ')
so in result I will have >>year>quarter>month
the problem is that if I will select more than 1 month it will sort months alfabeticaly.
Is there any way to stop sorting?
Thank you,
Andrzej
If you want the like: Jan, Feb, Mar.. then try like:
concat(Distinct month([DB Date]), ',', month([DB Date]))
the second 'month([DB Date])' defines the sort order.
Hi, maybe:
='>> ' &
Year
& ' > '&concat(DISTINCT if(len(Quarter)>1,Quarter), ', ')
& ' > '&concat(date([DB Date]), ', ', date([DB Date]))
If not, can you post a sample of the data to make tests?
In text i don't believe you sort it but you can use the straight table for this with only expression.
Regards,
Anand
I am sorry I add wrong formula in OP
the formula from OP works fine as it has full date. but i want to show months only, and then it sorts incorrectly:
='>> ' &
Year
& ' > '&concat(DISTINCT if(len(Quarter)>1,Quarter), ', ')
& ' > '&concat(month([DB Date]), ',')
please post sample data/app
If you want the like: Jan, Feb, Mar.. then try like:
concat(Distinct month([DB Date]), ',', month([DB Date]))
the second 'month([DB Date])' defines the sort order.
Thanks, this is what I needed. It works after little adjustment
concat(month([DB Date]), ', ',date([DB Date]))