How can I bring through the Nulls that exist in the original script. I have a couple of rows which dont have a month. But still want to show these...

thank you that works. How can I get the month to be in order like it should be jan-->Dec?

Sorry never done CTE? how would I join this onto my script?

I need something in java script for CRM 4.0

I have managed to get the following formula working in Excel where 2011 = 0 and 2012 = 9454 and it does not give me a divide by zero error...

It now gives me the answer 1. When the answer should be 100. (from the calculation)?

Same Problem?

for e.g.

My Field!TG__2012_YTD.Value is '0' and

Field!TG__2011_YTD.Value is 646?

CREATE TABLE [dbo].[Tpl_zonegwpBase](

[Tpl_zonegwpId] [uniqueidentifier] NOT NULL,

[Tpl_name] [nvarchar](100) NULL,

[Tpl_CompanyId] [uniqueidentifier] NULL,

[Tpl_Month] [nvarchar](6) NULL,

[Tpl_Channel] [nvarchar](100) NULL,

[Tpl_NBGWP] [money] NULL,

[Tpl_RenewalGWP] [money] NULL,

[Tpl_TotalGWP] [money] NULL,

[Tpl_Zone] [nvarchar](100) NULL,

CONSTRAINT [PK_Tpl_zonegwpExtensionBase] PRIMARY KEY CLUSTERED

(

[Tpl_zonegwpId] ASC

)WITH (PAD_INDEX...

I think it might be because the name column is only (50), can you change it to a (100)

Apologies forget to say how I could group the distinct users and there top GWP?

I think creating a calender table is going to be too tricky for me.

here is my data:

company yearmonth totalGWP

AIUA201001600.00

AIUA2010021666.00

AIUA2010031300.00

AIUA2010041136.00

AIUA2010051500.00

AIUA2010062800.00

AIUA2010071300.00

AIUA20100813200.00

AIUA20100910000.00

AIUA20101010000.00

AIUA20101112000.00

AIUA20101210000.00

AIUA20110122626.00

AIUA20110222826.00

AIUA201103582402.00

AIUA201104333842.00

AIUA20110547977.00

AIUA201106382950.00

AIUA20110717578.00

AIUA20110872243.00

AIUA20110917664.00

AIUA201110171336.00

AIUA201111169590.00

AIUA201112162118.00

so I have two years worth of data. I have the...

Hi Phil,

Im successfully getting the YTD figure for the current year, but how can i compare this figure to data for the for the equivalent month the year before?

So how would I be able to select totals for the year from the query? If it only returns 'NULL's?

I want my YTD to be summed up by Zone column YTD:

Zone 2011 YTD

Tango 2335

Apple...