LYTD is not ging correct result

[arulsettu]

     hi

i used this script for lytd

POL_APPROVAL_Date={">=$(=YearStart(max(date(POL_APPROVAL_Date)),-1))<=$(=num(addYears(Date(Today()-1),-1)))"}

POL_APPROVAL_Date = date(floor(tp_ap_date)

can any one suggest some idea

[satishkurra]

Try this. Assuming Sales is the measure and Use Date as POL_Approval_Date

=Sum({$<Date={">=$(=Num(YearStart(Max(Date),-1)))<=$(=AddYears(Max(Date),-1))"}>}Sales)

[arulsettu]

Sunny T here is the sample app pls take alook

[sunny_talwar]

No data to sum here

[arulsettu]

will check thanks for your time sunny