max function

[#1]

hi guys I am using the max function to return values for the maximum field number but somehow it returns all values

i.e:

Sum( {<Year={'$(vPriorYear)'}, Month={'$(vMaxMonth)'},Day={'<=$(vMaxDay)'},Date_Week_Num={">=$(=Num(Date_Week_Num(MAX(Date_Week_Num))))"}>}Counter_Num)

returns:

for the date of 2014/01/27 to 2014/01/31

[alexandros17]

What does this mean?

Date_Week_Num={">=$(=Num(Date_Week_Num(MAX(Date_Week_Num))

I shoul write

Date_Week_Num={">=$(=MAX(Date_Week_Num))

[#3]

hi Alessandro,

I have put your expression and I think what I am struggling with is to return the data for the Max week number of the prior year.......it gives me the values for the month not for that particular week.