MTD

[#1]

Hi,

I want MTD to be calculated, as my selection year is max(YEAR) and starting month will be April,

So when I select April I will get Current month data i.e April 2012 and March 2011 will be my previous month data,

but when I select March I am getting '0' , I should get previous month data that March 2011.

can any one help...

[martin59]

Hi,

I'm not sure to understand as well.

Have you already tried to make an expression ?

Martin Favier

[martin59]

Hi,

I'm not sure to understand as well.

Have you already tried to make an expression ?

Martin Favier

[martin59]

Hi,

I'm not sure to understand as well.

Have you already tried to make an expression ?

Martin Favier

[#5]

=sum({<YEAR={"$(=(MAX(YEAR)))"}, MONTH={"$(=max({<YEAR={$(=year(addmonths(max(DT),-1)))}>}MONTH)-1)"}>}Income/Factor)

this is my expression for prev. month but its not working if I select April 2012 as my 1st month so that it should give me prev year 2011 March data

[Anonymous]

Oopse the question is not at all clear.

I assume you want to compare two MTD columns, one for the current period and the other one for the same period last year? Or current period and previous period? Could you please confirm that you indicated the years correctly?

Help us to help you

Regards

MultiView

[#7]

Hi

I guess you are using for this a special detached table for dates to refer to. Do you?

Chris

[#8]

April 2012	March 2011	Gain
37.35		37.35
66.93	52.24	14.69

this my data when I select April 2012 which is my first month , so I should get March 2011 as my prev. month which I am getting '0'

April	1
May	2
June	3
July	4
August	5
September	6
October	7
November	8
December	9
January	10
February	11
March	12

so I should get value for prev month as March 2011 data

[Anonymous]

Hi,

   Your month dimension will be bypass into expression,you will get data and it won;t show zero value.

Regards