Having SUM trouble with total values ;)

[FrunkaBlunka]

Hi guys

On the report I have created the following as shown below. I thought I
would put some code in the on format event to hide lblCostInvoiced if
chkInvoiced was unchecked. Then I thought I could get a total in the
report footer using =Sum(lblCostInvoiced) but it asks me for a
parameter value when loading. I am pretty sure there is a better way
to do this I just can't get my head around it. Is it better to do this
with an IIF statement or some other method? Thanks!

DESGIN VIEW
-------------------------------------------------------------------------------------------------------------------------------------------------------------
lbl: [CLIENT] lblCost: [COST]
lblCostInvoiced: [=lblCost] chkInvoiced: [INVOICED]
-------------------------------------------------------------------------------------------------------------------------------------------------------------
ReportFooter =Sum([Cost])
=Sum(lblCostInvoiced)


REPORT VIEW

Client A
$10,000
$10,000 X
Client B
$11,000
Client C
$15,000
$15,000 X

 

[FrunkaBlunka]

Sorry that was supposed to look like this:

DESGIN VIEW
--------------------------------------------------------------------------------------------------------------------------
lblClient: lblCost: lblCostInvoiced: chkInvoiced:
[CLIENT] [COST] [=lblCost] [INVOICED]
--------------------------------------------------------------------------------------------------------------------------
=Sum([Cost]) =Sum(lblCostInvoiced)


REPORT VIEW

Client A $10,000 $10,000 X
Client B $11,000
Client C $15,000 $15,000 X