set analysis aggr function

[thierrytt1102]

Dear,

I'm developping an application concerning the sales of the 3 first months of a car.

Something like this:

Model	release date	Sales of the first 3 months
car 1	01/03/2014	1000 € (from 01/03/2014 to 01/06/2014)
car 2	02/03/2013	2000€
car 3	01/01/2012	3000€

In a straight table.

I'm using the expression:

sum({< [Period]=,[Day]=,[Weekday]=,[Year]=,[Month]=,[Quarter]=,[_MonthSerial]=,[_QuarterSerial]=,[_WeekSerial]=,[Year-Month]=,

Period={">=$(=only(ReleaseDate))"}*{"<=$(=addmonths(only(ReleaseDate),2))"}

>} Sales)

It is working fine when I select 1 car in my list box but not when I want to see all my vehicles.

I tried with an aggr function in my set analysis but no results.

Thx for your help

[pokassov · Accepted solution]

He!

Just replace you conditions with Period in somthing like this

sum({$<...>} if(Period>ReleaseDate and Period<=addmonths(only(ReleaseDate),2), Sales))

[thierrytt1102]

That doesn't look beautiful to me ... but it works!

thx