Summing Amount from Records with Yes checked off in Awarded field

[Guest]

I want the report to give me a sum of the proposal amounts for those records
that have been checked off as awarded (I have the awarded field as a Yes/No).
I have a text box already created that counts the number of awarded
contracts. What I'd like is another text box to give me the sum of the dollar
values of those records that have Yes checked for [Awarded].

 

[Rick Brandt]

I want the report to give me a sum of the proposal amounts for those records
that have been checked off as awarded (I have the awarded field as a Yes/No).
I have a text box already created that counts the number of awarded
contracts. What I'd like is another text box to give me the sum of the dollar
values of those records that have Yes checked for [Awarded].

=Sum(IIf([awarded] = True, [AmountField], 0)

 

[Guest]

I want to sum the total of the open bids. Basically, if they haven't been
awarded and its not lost, it is open. I used the following but it is giving
me the total of all bids, not just the open ones. What is wrong with this
code?

=Sum(IIf(([Awarded]=False) & ([Lost]=False),[Proposal Amount],0))

I want the report to give me a sum of the proposal amounts for those records
that have been checked off as awarded (I have the awarded field as a Yes/No).
I have a text box already created that counts the number of awarded
contracts. What I'd like is another text box to give me the sum of the dollar
values of those records that have Yes checked for [Awarded].

=Sum(IIf([awarded] = True, [AmountField], 0)

 

[Rick Brandt]

I want to sum the total of the open bids. Basically, if they haven't been
awarded and its not lost, it is open. I used the following but it is giving
me the total of all bids, not just the open ones. What is wrong with this
code?

=Sum(IIf(([Awarded]=False) & ([Lost]=False),[Proposal Amount],0))

You need "And" instead of "&"