Announcements
cancel
Showing results for
Did you mean:
Contributor III

## Comparison between previous season and current season

Hi

Current season is summer 2018.

With below expression, it returns the value for same time LY.

I need it to return  summer 2017.

if(Wildmatch(\$(ObjectList),'*Week*'), Sum({<Year = {\$(vMinYear)}>} [Cls Stk Value]),if(Wildmatch(\$(ObjectList),'*Month*'), Sum({<Year, \$(vClearDates),[SK LDOW No] = P({<[SK Ldom No] -= {\$(vMaxLdowLdomPrevious)}>} [SK Ldom No])+{\$(vCurrentMonthLdowPrevious)} >} [Cls Stk Value]),if(Wildmatch(\$(ObjectList),'*Season *'), Sum({<Year, \$(vClearDates), [SK LDOW No] = P({<[Numeric Yr Ssn Code] -= {\$(vMaxPrevSsnCode)}>}SeasonEndLdow)+{\$(vMaxLdowPrevious)} >} [Cls Stk Value]),if(Wildmatch(\$(ObjectList),'*Year*'), Sum({<Year, \$(vClearDates), [SK LDOW No] = P({<Year -= {\$(vMinYear)}>}YearEndLdow)+{\$(vMaxLdowPrevious)} >} [Cls Stk Value]),Sum({<Year, \$(vClearDates), [SK LDOW No] = {\$(vMaxLdowPrevious)} >} [Cls Stk Value])))))
+
if(Wildmatch(\$(ObjectList),'*Week*'), Sum({<Year = {\$(vMinYear)}>} [In Trnst Value]),if(Wildmatch(\$(ObjectList),'*Month*'), Sum({<Year = {\$(vMinYear)}, \$(vClearDates),[SK LDOW No] = P({<[SK Ldom No] -= {\$(vMaxLdowLdomPrevious)}>} [SK Ldom No])+{\$(vCurrentMonthLdowPrevious)} >} [In Trnst Value]),if(Wildmatch(\$(ObjectList),'*Season *'), Sum({<Year = {\$(vMinYear)}, \$(vClearDates), [SK LDOW No] = P({<[Numeric Yr Ssn Code] -= {\$(vMaxPrevSsnCode)}>}SeasonEndLdow)+{\$(vMaxLdowPrevious)} >} [In Trnst Value]),if(Wildmatch(\$(ObjectList),'*Year*'), Sum({<Year = {\$(vMinYear)}, \$(vClearDates), [SK LDOW No] = P({<Year -= {\$(vMinYear)}>}YearEndLdow)+{\$(vMaxLdowPrevious)} >} [In Trnst Value]),Sum({<Year = {\$(vMinYear)}, \$(vClearDates), [SK LDOW No] = {\$(vMaxLdowPrevious)} >} [In Trnst Value])))))

Labels (2)

0 Replies