C
cmk
I am about at my wits end
I have a group called Stock Type, Then I have a group called Cert #. I am
trying to have a subtotal of the purchased column by stock type
In my details section I have a count formula [CtRec] over group. I have
another formula called [Purchased]=IIf([CtRec]=1,[OriginalValue],0)
I can get everything but the subtotal line to work.
Cert# Original Value Trans Amt count Purchased Stock
Type
aaa 100 -10 1 100
CS
aaa 100 -5 2 0
CS
bbb 300 -2 1 300
CS
ccc 150 -20 1 150
CS
subtotal 550
ddd 1000 -1 1 1000
CS
ddd 1000 -3 2 0
CS
eee 2000 -4 1 2000
CS
eee 2000 -5 2 0
CS
subtotal 3000
I have a group called Stock Type, Then I have a group called Cert #. I am
trying to have a subtotal of the purchased column by stock type
In my details section I have a count formula [CtRec] over group. I have
another formula called [Purchased]=IIf([CtRec]=1,[OriginalValue],0)
I can get everything but the subtotal line to work.
Cert# Original Value Trans Amt count Purchased Stock
Type
aaa 100 -10 1 100
CS
aaa 100 -5 2 0
CS
bbb 300 -2 1 300
CS
ccc 150 -20 1 150
CS
subtotal 550
ddd 1000 -1 1 1000
CS
ddd 1000 -3 2 0
CS
eee 2000 -4 1 2000
CS
eee 2000 -5 2 0
CS
subtotal 3000