Expression using "total,for and "between

[thart21]

Hi,

I'm trying to get an expression to work in Report Studio 10.1.1 but it is giving me only 0 and 1 for results in the column.

total([Presentation Layer].[Sales Order Delivery].[DC Shpd Qty] for [Presentation Layer].[Sales Order].[SO Doc Hdr Nbr]) between 1 and 9

What I am trying to get is
Add up the DC Shpd Qty for each SO Doc Hdr Nbr where DC Shpd Qty is between 1 and 9

Any ideas as to how I should do this would be appreciated.

Thanks,

Toni

[blom0344]

case when
[Presentation Layer].[Sales Order].[SO Doc Hdr Nbr] between 1 and 9
then
total([Presentation Layer].[Sales Order Delivery].[DC Shpd Qty] for [Presentation Layer].[Sales Order].[SO Doc Hdr Nbr])
else 0 end