K
Koral
I have a Sum function in a Wizard generated report:
=Sum([Amount])
Now, I want to create another text box, where the SUM should base on the
VALUE OF ANOTHER FIELD:
The [Amount] values should be summed up ony where the [Payment Status] field
contains the value "Invoiced". I get error whatever I have tried!
If I could success, I would like to add another SUM box for the case where
the referenced field contains another value.
Can anybody please help?
Involved fields, values and conditions:
Field: [Payment Status]
Possible values: "Payed", "Pending" and "Invoiced"
Condition: [Payment Status] field value = "Invoiced"
Task: Calculaıte and output all the values of [Amount] field where the
[Payment Status] field of the same record is "Invoiced"
Note: The report is already in an outlined structure. That is, the records
shown are grouped under an [Outsourcer] field. That is, the SUM should
involve only those entries that are listed under that outsourcer.
There is the following automatically generated footer above the existing SUM
function:
="Summary for " & "'Outsourcer' = " & " " & [Outsourcer] & " (" & Count(*) &
" " & IIf(Count(*)=1;"detail record";"detail records") & ")"
=Sum([Amount])
Now, I want to create another text box, where the SUM should base on the
VALUE OF ANOTHER FIELD:
The [Amount] values should be summed up ony where the [Payment Status] field
contains the value "Invoiced". I get error whatever I have tried!
If I could success, I would like to add another SUM box for the case where
the referenced field contains another value.
Can anybody please help?
Involved fields, values and conditions:
Field: [Payment Status]
Possible values: "Payed", "Pending" and "Invoiced"
Condition: [Payment Status] field value = "Invoiced"
Task: Calculaıte and output all the values of [Amount] field where the
[Payment Status] field of the same record is "Invoiced"
Note: The report is already in an outlined structure. That is, the records
shown are grouped under an [Outsourcer] field. That is, the SUM should
involve only those entries that are listed under that outsourcer.
There is the following automatically generated footer above the existing SUM
function:
="Summary for " & "'Outsourcer' = " & " " & [Outsourcer] & " (" & Count(*) &
" " & IIf(Count(*)=1;"detail record";"detail records") & ")"