Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hello dears,
I have a list box including the Shamsi Months ( Months in Persian),
I tested all of the sort options (state,expressions,frequency...) but it does not get sorted as i wanted it to be.
I want to order them as it is in calender, apparently i have to sort them manually. but how?
thank you
I'm sorry but i don't get it, You see the month field has 12 possible values,the months in Persian, When i add the month list box, i want them to be ordered.
i did not get the load inline part, what is the amount field? my original table has almost 20 column. not just 3.
Hi,
As you could not give me sample file I have created a sample data that meet your requirement.
For month sorting did you follow my above post.
or you can use the below expression in sort tab.
=Match(Month,'اسفند','بهمن','دی','آذر','آبان','مهر','شهریور','مرداد','تیر','خرداد','اردیبهشت','فروردین')
Without seeing data I can't tell you how your data looks like.
No issue with the number of fields you have.
Hope it helped.
Regards
ASHFAQ
Hey Arman
I have seen your expression you have written in a wrong way. You have used Double Quotes ( '' ) for the Shamsi Months fields which is the wrong Format for writing the Expression.
Don't use double Quotes. Write the field names as it is.
Use this Expression:
Dual([Shamsi Month],Match([Shamsi Month],'فروردین','اردیبهشت','خرداد','تیر','مرداد','شهریور','مهر','آبان','آذر','دی','بهمن','اسفند'))
I am sure it will work for you.
Thank you. It worked for the problem I had with my project.