set analysis aggr function

thierrytt1102 — Wed, 01 Apr 2015 13:08:42 GMT

Dear,

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

Something like this:

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

Re: set analysis aggr function

pokassov — Wed, 01 Apr 2015 13:26:09 GMT

He!

Just replace you conditions with Period in somthing like this

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

thierrytt1102 — Thu, 02 Apr 2015 09:47:10 GMT

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

thx