Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
He!
Just replace you conditions with Period in somthing like this
sum({$<...>} if(Period>ReleaseDate and Period<=addmonths(only(ReleaseDate),2), Sales))
He!
Just replace you conditions with Period in somthing like this
sum({$<...>} if(Period>ReleaseDate and Period<=addmonths(only(ReleaseDate),2), Sales))
That doesn't look beautiful to me ... but it works!
thx