MTD not working

[#1]

Hi all,

Iam wroung some where please do let me know

I am just calculation YTD and MTD using set analysis

here is my expression

=if(Category='receivable',sum({<YEAR={'<=$(=MAX(YEAR))'},MONTH={'<=$(=MAX(MONTH))'}>} $(EXP)))

here if YTD is working fine,but not MTD ..,

please do let me know where iam wroung

Regards,

Kiruthiga

[#2]

Hi,

May I know the value of $(EXP).

Regards,

Janzen

[#3]

HJanzen,

Thanks,

$(EXP) = if(val=5,val2,val3)---> I made that as a variable,but there is not problem in this,because,

only if I calculate YTD its working fine

[#4]

HJanzen,

Thanks,

$(EXP) = if(val=5,val2,val3)---> I made that as a variable,but there is not problem in this,because,

only if I calculate YTD its working fine

[#5]

Hi,

Can you give the expression you used for MTD? It should work using this expression.

=if(Category='receivable',sum({<YEAR={$(=MAX(YEAR))},MONTH={'<=$(=MAX(MONTH))'}>} $(EXP)))

Regards,

Janzen

[#6]

Hi,

I used the same expression

as yours which is in the starting of my post..,

is there anything do with the month alone say 1-12 after that 13,14,15..for the next year??

any idea?

because I am not getting only MTD..,

[#7]

Hi,

There is a difference between this expression compared to your earlier post. This is for MTD computation.

=if(Category='receivable',

sum({<YEAR={$(=MAX(YEAR))},

MONTH={'<=$(=MAX(MONTH))'}>}

$(EXP)))

while this one is for YTD

=if(Category='receivable',

sum({<YEAR={'<=$(=MAX(YEAR))'},

MONTH={'<=$(=MAX(MONTH))'}>}

$(EXP)))

Hope this will help

Regards,

Janzen

[#8]

Hi Janzen,

sorry in delay replying ,I tried with MTD but it is showing the exact value

means if i select feb 2011 it is giving only feb 2011 data,

but i need from jan 2010 to feb 2011 value for selecting feb 2011(Data is available from jan 2010 only)

[#9]

Hi,

Sorry I was confused with your question. What do you really need? Based on what I know MTD means from the first day of a selected month and last day of a particular month. Example if you choose Feb 2011, MTD means from Feb 1, 2011 up to Feb 28, 2011. YTD means from the first day of a selected year up to the selected day and month. Example if you choose Feb 2011, YTD means from Jan 1, 2011 up to Feb 28, 2011. May I ask for your definition of MTD and YTD?

Regards,

Janzen

[#10]

Hi Janzen,

Thanks

Sorry for confusing you,

my requirement is

if you choos Feb ,2011

if the data in database is from say  jan 2010

then it need to display data from Jan 2010 to feb ,2011

my problem is if I select only year say 2011,it is givin the sum of data(2010 + 2011 for 2011) correctly,

but if I choose the month after year selection say febafter selecting year -2011,the data is comming wroung

But YTD is enough for my scenario I think so and my expression below

if(Category='receivable',sum({$<Year={"<=$(=max(Year))"}>}$(exp))

Its very urgent ,i need to completethis by today..,there is some small mistake in my expression which iam not able to deduct..,

Hope to hear from you

Kiruthiga