ADD COLUMN WITH NULL'S

A

Akrt48

I am trying to get a sum in a report that has fields above it which return
some values in some of them there are no values but there might be next
month. I am trying to get a sum at the bottom, but having no luck if I
include the fields with null. I know NZ works horizontally can you please
tell me what works on a column. Thanks
 
T

Tom Lake

I am trying to get a sum in a report that has fields above it which return
some values in some of them there are no values but there might be next
month. I am trying to get a sum at the bottom, but having no luck if I
include the fields with null. I know NZ works horizontally can you please
tell me what works on a column. Thanks
Click to expand...

Sum(Nz([yourfield], 0))

Tom Lake
 
A

Akrt48

Thank you both, I had done that but must have had a syntax wrong, and then I
saw somewhere that it would only work across rows. I will pay more attention
next tim

Tom Lake said:
I am trying to get a sum in a report that has fields above it which return
some values in some of them there are no values but there might be next
month. I am trying to get a sum at the bottom, but having no luck if I
include the fields with null. I know NZ works horizontally can you please
tell me what works on a column. Thanks
Click to expand...

Sum(Nz([yourfield], 0))

Tom Lake
Click to expand...
 
Top