Calculate partial totals per report group according to criteria specified in group

[fugifox]

I have a report which has two nested grouping levels like the following schema.
Report
--Group1
----Group2

Inside Group2 there's a field holding the cost of the product
and 3 True/False fields indicating whether the corresponding features of the product are available.
What I want is to add 3 calculated fields inside Group2 each of which will give me the sum of each feature.
I initially tried Dsum() but it doesn't seem to match my case since it doesn't collect the data from the report as Sum() does but you have to specify a "domain" (us. a table) resulting in calculating the total sum and not per Group as in my case.

Any suggestion would be far more than just helpfull.
Thanks in advance

 

[Ziggy1]

try this in your detail

=IIf([Avail]=1,[QTY],0)

the one represents TRUE

This where you want the total....


=Sum(IIf([Avail]=1,([QTY]),0))

 

[fugifox]

Thanks for the reply,
but I didn't quite understand what do you mean by [Avail]

 

[fugifox]

Never mind I got your point.
It's a really smart way.
Thanks for your reply.

 

[Ziggy1]

glad it worked