Calculating SUM

[Guest]

Hi all,

I have a field in my report with the control source as follows:
=((([Cash-VND]/[ExchRate]) & [BA-176-USD_G] & ([BA-305-VND_G]/[ExchRate]) &
[BA-351-USD_G] & ([BA-324-VND_G]/[ExchRate]))*-1)

The field is aimed to display the results (USD amount) for only 1 out of 5
fields (the one which is not Null) - works fine.

But I want to calculate a SUM of this field in the Report's Footer as well -
is there any way i can do that? I am out of solutions....

Thank you.
Lana

 

[Guest]

In the control source of the text field in the report footer write

=Sum(((([Cash-VND]/[ExchRate]) & [BA-176-USD_G] &
([BA-305-VND_G]/[ExchRate]) & [BA-351-USD_G] &
([BA-324-VND_G]/[ExchRate]))*-1))

 

[Guest]

When you want to sum on a calculated field, you should do the Sum on the
calculation and not the field name

So, if you have in a control source of a field
=[Field1] + [Field2]

The sum will be
=Sum([Field1] + [Field2])

And not
=Sum([The field name that contain the formula])