month

[#1]

I have field called month_order (FY:Apr to Mar) now I need to use in set analysis

In text object,  max(month_order ) here am getting 12

I want to show Max Month Dec

I have tried with monthname(month_order) and test(month_order) but not working.

any ideas pls suggest!

[m_woolf]

You can define your month_order field in script using dual to give the field both a numeric and string value.

Shouldn't you want max(month_order) to show Mar?

[#3]

With dual I have given already like dual('Apr',1)...............................................................('Mar',12)

In text object am using max(month_order) it returns 12 only

I want to show max month as Mar

how do I use in set analysis??

[Frank_Hartmann]

attached sample might be helpful

[#5]

That is fine but how do we use in set analysis???

If I use in text object max(month) its giving me 12

I nee to to show employee count max month.

[Frank_Hartmann]

in textbox try like:

=only(aggr(max(Month),SortOrder))

hope this helps

[tresB]

If you need 'Dec' instead of 12, try like:

=Month(MakeDate(1, max(month_order )))