Results 1 to 8 of 8

Thread: Crystal Reports v10 - Formula adding several fields, any of which may be null

Threaded View

  1. Apr 23rd, 2009, 01:29 PM #1
    huddy33
    huddy33 is offline

    Thread Starter
    Junior Member
    Join Date
    Apr 2009
    Posts
    24

    Crystal Reports v10 - Formula adding several fields, any of which may be null

    I am not sure how to add these fields together in a formula and always return a value, be it 0 or >0. They are currency fields and the majority of the eight fields will be null. Those that are not null in the formula are still returning a null value overall, after stopping with the first null evaluation. How can I write this?

    I've tried trimming the field and <>"", but nothing works. Thanks for any help!
    Last edited by huddy33; Apr 23rd, 2009 at 01:41 PM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width