Quarter Field Values should be First,second

[#1]

Hi community members,

Is their any way to represent the Quarter field values First, Second, Third and Fourth

instead of 1,2,3,4, can one help me please

Regards,

ramesh

[#2]

Create a mapping table to map values 1,2,3,4 as First, Second, Third and Fourth and use the applymap to use in your main transaction table.

[#3]

If it is just in a list box for aesthetic purposes, you can use the Dual() function:

=

Dual(
if(Quarter='Q1','First',
if(Quarter='Q2','Second',
if(Quarter='Q3','Third',
if(Quarter='Q4','Fourth')))),Quarter

)

Then you can sort using Match()

[its_anandrjs]

Hi,

Create another field some thing like

if('Q' & Ceil(Month(Date) / 3) = 'Q1','First',

if('Q' & Ceil(Month(Date) / 3) = 'Q2','Second',

if('Q' & Ceil(Month(Date) / 3) = 'Q3','Third',

if('Q' & Ceil(Month(Date) / 3) = 'Q4','Fourth',

))))  as NewQuarter,

HTH

Regards,

Anand

[#5]

can you please give the sample example of mapping, I am unware of the mapping function