Thanks Adi. I misunderstood the query. Now all good, thanks!

I need to sum all the columns.

Hi Sean,

I am sorry and I made this drag a long way. Will post clearly soon on this.

Hi Sean,

It's not a running total. The business rule for PriorVersion is sum(PreviousYear), so that I get PriorVersion values. And variance should be done for (PreviousYear - PriorVersion).

Lee me know...

Hi Sean,

I wasn't clear what I have to mention for that Priorversion column. So just mentioned the previous year. I have updated my post. Hope it helps.

Hi Sean,

Updated my post.

Hi,

You are correct. I disclosed some dummy raw data to show the expected output.

But this is the one that should be happening there.

PriorVersion will be like sum(PreviousYear)

Variance will be...

It worked. Thanks a lot.

Yeah it worked. Thanks

I am using the below query and doesn't work

SELECT LTRIM(Cost) FROM Application

I changed the datatype to int. But now when I run the query It says invalid column name for cost.

Table Schema:

CREATE TABLE [dbo].[Application](

[ID] [int] NOT NULL,

[Date] [date] NULL,

[ Cost] [int]...