need help

[#1]

I want to get last year saleQty and the this year saleQty by selecting a year and a month. Financial year begins from April. i m getting last year saleQty for a month like this.

Num((SUM({<year = {'$(=Max(year)-1)'}>}saleQty)),'#,##0')

but now i want to get saleQty for a period(April to this month) for last year and this year. pls help

[jagan]

Hi Dushan,

Then use this expressions

For Previous Year YTM:

SUM({<Date={'>=$(=YearStart(Today(), -1, 4))<=$(=AddMonths(Today(), -12))'}>}saleQty)

For Current Year YTM:

SUM({<Date={'>=$(=YearStart(Today(), 0, 4))<=$(=Today())'}>}saleQty)

Regards,

Jagan.

[#3]

Hi, Jagan i tried this before. but it s displaying month value only not the YTM. can u please send me the corrected copy

[jagan]

Hi,

Try like this

For Previous Year YTM:

SUM({<Date={'>=$(=YearStart(Max(Date), -1, 4))<=$(=AddMonths(Max(Date), -12))'}>}saleQty)

For Current Year YTM:

SUM({<Date={'>=$(=YearStart(Max(Date), 0, 4))<=$(=Max(Date))'}>}saleQty)

Regards,

Jagan.

[#5]

hi jagan, it s only displaying monthly saleQty

[jagan]

Hi,

Can you attach the file which you are working now and specify what is the some expected values for YTM and LYTM.

Regards,

jagan.

[#7]

Hi,

total YTM to 2014-1 is 24,476,166 nearly. your previous method is correct. but it should change when year and month is changing

[#8]

can someone correct the application copy which i previously attached and send me ? thanks

[jagan]

Hi,

Can you reattach the copy and let me know the values you expect when you select specific year and month.

Regards,

Jagan.