Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
Now i am doing Validation..
i have month id's like (201201,201202,201203........201212)Jan to Dec..
i am trying to calculate Quarter values..but it's not giving Cumulative values..it's giving value for each month...
can any one help me to get that values for each quarter...
Thanks!!!
Smiley
HI,
Create a quarter in script.
Something like this.
Ceil(num(Month(Makedate(right(Field,4),Left(Field,02))))/3) as Quarter.
Here Field is the column name which has text inthe form of YYYYMM.
One you get the correct Quarters then use the Quarter field in your chart/Groups to get Values according to Quarter.
Regards,
Kaushik Solanki
Hi Kaushik,
Thanks for ur replay
But i need to calculate that in Sql Server
so, i need SQL Query