Set Analysis - Value by max date of previous year

[pamaxeed]

Hi guys,

i am struggling a bit with Set Analysis, maybe some of you can give me a hint how i can solve the following problem:

I have different kind of properties with a specific market value, which can be delivered more times during a year.

What I already achieved is to get the last registered marketvalue when i select a year

Her my solutions:

1. Sum(aggr((FirstSortedValue(#UEBE_MARKTVALUE,- UEBE_DATE_PER)),UEBE_ID))
2. Sum(If(Aggr(NODISTINCT Max(UEBE_DATE_PER), UEBE_ID) = UEBE_DATE_PER, #UEBE_MARKTVALUE))

Both works fine.

Now i want ot have the market value of the previous year using set analysis indeed, how i can achieve it?

I tried with the following statement but it is not working:

Sum({<FACT_YEAR=, UEBE_YEAR={"$(vPreviousYear)"}, #UEBE_MARKTVALUE={"If(Aggr(NODISTINCT Max(UEBE_DATE_PER), UEBE_ID) = UEBE_DATE_PER, #UEBE_MARKTVALUE)"}>} #UEBE_MARKTVALUE)

Is someone out of there who can give me a hint how to solve it?

Thanks,

Patric

[stigchel]

Maybe

Sum({<FACT_YEAR=, UEBE_YEAR={"$(vPreviousYear)"}, #UEBE_MARKTVALUE={"=Aggr(NODISTINCT Max(UEBE_DATE_PER), UEBE_ID) = UEBE_DATE_PER"}>} #UEBE_MARKTVALUE)

[pamaxeed]

I already tried but it is not working...

[pamaxeed · Accepted solution]

Finally I have solved it:

sum({<FACT_YEAR=, UEBE_YEAR_PER={'$(vPreviousYearT1)'}>}

aggr(only({$<FACT_YEAR=, UEBE_YEAR_PER={'$(vPreviousYearT1)'},UEBE_DATE_PER={"$(=max({<FACT_YEAR=, UEBE_YEAR_PER={'$(vPreviousYearT1)'}>}UEBE_DATE_PER))"}>}#UEBE_MARKTVALUE)

,#UEBE_MARKTVALUE))

Thanks for your help anyway!