Quarter Field values should be Q1,Q2...

[#1]

Hello communtiy members,

I have created field Quarter, but I want the values to be in Q1,Q2...format...default values are 1,2,3.

please any one you help me

regards

Ramesh

[MayilVahanan]

HI

Try like this

'Q' & Ceil(Month(Date) / 3)

Hope it helps

[#3 · Accepted solution]

I am getting extra 'Q' Value

in fiield, can say where is the problem

q1,

q2,

q3,

q4,

q

in this manner

[MayilVahanan]

Hi

For view in list box

=if(isnull(Quarter),'', 'Q'&Quarter)

but you want to create a field , you must want to load in script oly

[#5]

Hi ramasamy, can you please correct me why I am getting the q value, I am attaching my file please correct me,

and I have another problem also

I want to represent values the gauge charts, can you please correct me in this issue also

Regards

Ramesh

[#6]

Hi ramasamy,

I resolved the issue, I have the record, which contains a date of some 51, so it doesnot fall under these four quarters, it is defaultly taking another value as Q

regards,

ramesh

[MayilVahanan]

Hi

  You can use inline table for it..

Load * inline

[

Month,Quarter

Jan,Q1

Feb,Q1

Mar,Q1

...

Dec,Q4

];

Hope it helps..

So it avoid that issue.. i can't reload the script because of qvd n xls..