Same Query Item but Different Conditions

[gosoccer]

Hi Folks, :) :)

the following is not working when I need to roll up the Numbers to Total. Pls see  below code,
In the Data Item, as an Expression, I have the following,

Expression: (Works)
CARX_COUNT

if ( [ID Report].[Rpt_Data].[CAR_TYP_CD] in_range
{'10':'20'} 
then (1)
else (0)

Now, I have a secondary Data Item that is setup based on the following,
Data Item: Expression
Expression: CARX_COUNT (From above)
Aggregation Func. Calculated
Roll up Aggregation Fund: Total
Detail: Automatic
Calc Intesect: Show Value

So, I was hoping that when I drop this Data Item as a part of my List, it'll total up
all the counts but it's not.

Any help would be great.

Thx :) :)

[HalfBloodPrince]

Try this

total(if ( [ID Report].[Rpt_Data].[CAR_TYP_CD] in_range
{'10':'20'} 
then (1)
else (0) )

[hespora]

Aggregation Func. Calculated
Roll up Aggregation Fund: Total

Just set those to total and none, respectively.