ADD COLUMN WITH NULL'S

[Guest]

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

 

[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

Sum(Nz([yourfield], 0))

Tom Lake

 

[Guest]

Try
=Sum(Nz(FieldName,0))

 

[Guest]

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

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

Sum(Nz([yourfield], 0))

Tom Lake