Joined: 19 Mar 2008
Online Status: Offline
Posts: 1
Topic: Adding with null values Posted: 19 Mar 2008 at 3:56pm
I'm trying to add field values together to get a total in another field. The problem is that one of the fields may have null value in it. When it does, Crystal does not want to add any of the other fields and returns a blank. What syntax do I use to make Crystal add all the fields regardless if one of them is null?
Normally, in MS Access I would use nz. But obviously doesn't work with Crystal.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum