SUM (?) in Report

  • Thread starter Thread starter an
  • Start date Start date
A

an

Hello!
In Report I have:
Textbox1 to display VolPurge1 (numeric data field);
Textbox2 to display VolPurge2 ( " " " );
and so on, to
Textbox9 to display VolPurge9 (Numeric data field too).
I need to Sum values independently fields are filled or
not.
When there are numeric data in all fields, the SUM work
fine. When only one field is null the SUM don't work.
I would like help to this problem with formulae, please.
Thanks in advance.
an
 
Textbox1 to display NZ([VolPurge1],0)
If VolPurge1 is Null the NullToZero function will display a zero.

and/or you can use the following in your Footer:
Sum(NZ([VolPurge1],0))
 
Sorry but when run, return msg "Enter parameter value" (?).
Thanks.
an
-----Original Message-----
Textbox1 to display NZ([VolPurge1],0)
If VolPurge1 is Null the NullToZero function will display a zero.

and/or you can use the following in your Footer:
Sum(NZ([VolPurge1],0))

--
George Nicholson

Remove 'Junk' from return address.


Hello!
In Report I have:
Textbox1 to display VolPurge1 (numeric data field);
Textbox2 to display VolPurge2 ( " " " );
and so on, to
Textbox9 to display VolPurge9 (Numeric data field too).
I need to Sum values independently fields are filled or
not.
When there are numeric data in all fields, the SUM work
fine. When only one field is null the SUM don't work.
I would like help to this problem with formulae, please.
Thanks in advance.
an
Click to expand...


.
Click to expand...
 
Are you summing across fields within one record or summing one field across
multiple records?
 
Ok.
I need to sum all values in same record.

Record 1
VolPurge1 value +
ValPurge2 without value +
ValPurge3 value +
ValPurge4 without value +
.... +
ValPurge9 value

in same record (Page1).

In another Page:

Record 2
VolPurge1 withou value +
ValPurge2 value +
ValPurge3 value +
ValPurge4 without value +
.... +
ValPurge9 without value

Thanks for you reply
an
 
Ok, GN!

I changed NZ([VolPurge1],0)
to NZ([VolPurge1];0)
and work fine.

Sincerely, thanks for your help.
an
-----Original Message-----
Textbox1 to display NZ([VolPurge1],0)
If VolPurge1 is Null the NullToZero function will display a zero.

and/or you can use the following in your Footer:
Sum(NZ([VolPurge1],0))

--
George Nicholson

Remove 'Junk' from return address.


Hello!
In Report I have:
Textbox1 to display VolPurge1 (numeric data field);
Textbox2 to display VolPurge2 ( " " " );
and so on, to
Textbox9 to display VolPurge9 (Numeric data field too).
I need to Sum values independently fields are filled or
not.
When there are numeric data in all fields, the SUM work
fine. When only one field is null the SUM don't work.
I would like help to this problem with formulae, please.
Thanks in advance.
an
Click to expand...


.
Click to expand...
 
Apparently you have found the Nz() function.
Just a word of total conjecture... adding values across a record generally
suggests un-normalized data. 9 repeating columns isn't usually the best
method of storing data.
 
Back
Top