Calculate LMTD

[#1]

Hi

       I want to Calculate Last Month till Date Sales. I have Selected 12 Oct -13 . I want to Calculate 01-Sep to 11-Sep-13.. Can u Please Suggest me the query

[#2]

Try this one,

date={'>=monthstart(max(date),-1)<MakeDate(year(max(Date)),Month(Max(Date))-1,day(max(Date)))'}

[#3]

=Sum({<FinYear=,FinMonthName=,FinancialYear=,FinQuarter=, DateField={">=$(=Date(monthstart(vMaxDate,-1)))<=$(=Date(monthend(vMaxDate)))"}>}sales)

vMaxPrvDate=Date(max(CommonDateField),'DD/MM/YYYY')

[salto]

Hi,

maybe not the most elegant but I would try substracting the current month sales to to the total sales in the year, and then show the result:

=num(sum({<Year={$(=Max(Year))}> } SalesAmount))

-

num(sum({<Year={$(=Max(Year))}, MonthNum={$(=max(MonthNum)-1)} > } SalesAmount))

Hope this helps.

[#5]

Hi,

      Can U please explain the Expression. Because I have Date, Month , Year, Values Only

[#6]

I think this expression using set analysis will work :

sum( {< date={">=$(=monthstart(max({1}date),-1)) <$(=max({1}date))"} >} SALES)

we select the date for which to calculate the sum of sales.

Regards

Stéphane