lytd

[kunkumnaveen]

Hello All,i want to known the expression the one i written is correct on are not please

suppose i got a field name

li

salesdate(dd-mm-yyyy)

01-01-2014

02-01-2014

----------------

------------

------------

31-12-2015

what i want  to say is like i got 2 yr of data, the expression what i had written for LYTD IS some thing like this\

sum({$<salesdate={">=$(=yearstart(max(salesdate)-1))<=$(=date(addmonth(max(salesdate),-12)))}>}sales)

[Chanty4u]

hi,

go through below link

Re: YTD vs LYTD

thanks

suresh