Need max year, max month and max day using set analysis

[#1]

Dear All,

i need to show max year, max month & max day of sales, so i used following function , but its not showing the amount of sales.

Pls see below function.

=Sum({$<Year = {$(=max(Year))}, Month = {$(=month(addmonths(max(Month) , -1)))},Day = {$(=max(Day))}>} Amount)

Regards,

Antony.

[marcohadiyanto]

hi, if you want max month, why your month (-1) ?

[syed_muzammil]

Hi,

Can't you use just a date field instead of all this. I mean

Date={$(=Date(Max(Date)))}.

[#4]

Hi,

-1 is the default for max month

if you max month is Dec then -1 will show the month of "Dec" , when you mention -2 then it will show the previous month " Nov".

Please use the condition & check in your application.

[#5]

i used the below conditon, but its showing "0"

sum({$<Date={$(=Date(max(Date)))}>}Amount)

[deepakk]

Hi,

Create a MonthNum at script level

eg : Num(Month) as MonthNum

And use the below expression

Sum({$<Year = {$(=max(Year))}, MonthNum = {$(=month(max(MonthNum)-1))},Day = {$(=max(Day))}>} Amount)

I hope this helps....

[#7]

Hi Deepak,

Only for Month or i have to do it for year & day also.

[#8]

Hi deepak,

I used the below expression as per your instruction but its showing "0".

Sum({$<Year = {$(=max(Year))}, MonthNum = {$(=month(max(MonthNum)-1))},Day = {$(=max(Day))}>} Amount)

upto Month its showing correctly when i add "Day ={$(=max(Day))}" in the above expression then its showing the Amount "0"

[deepakk]

HI,

First Check out what Date your getting in Max(Year) & Max(MOnthNum) & Max(Day)...

if its 2010 10 1 then check if you have any Amount for that particular.

[deepakk]

hi,

Also check the formatting of dates.

eg :

Day in backend would be 01 or 02 but when you say Max(Day) it might become 1 or 2.

Thia might also be the reason for 0 Amount.