Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
Sunny T here is the sample app pls take alook
No data to sum here
will check thanks for your time sunny