Solved

Summary Function not displaying zero

Posted on 2013-02-04
4
382 Views
Last Modified: 2013-02-04
I got a summary function that doesn't display zeroes, although I've made sure that in the Format Editor / Number/ Customize, that "suppress zero" is not checked, yet, I still get blank instead of zeroes, any thoughts?

Thx
0
Comment
Question by:Roberto Madro R.
  • 2
4 Comments
 
LVL 18

Assisted Solution

by:vasto
vasto earned 100 total points
ID: 38851947
Do you have null values in any of the records ?
0
 
LVL 18

Accepted Solution

by:
UnifiedIS earned 300 total points
ID: 38852032
Replace nulls with zero in your data source or with a formula


Formula:

IF ISNULL(field_you_are_summarizing) THEN
0
ELSE
field_you_are_summarizing

Replace the field on the report with the formula and summarize the formula
0
 

Author Comment

by:Roberto Madro R.
ID: 38852097
The formula I have in the Detail section is simple but I use it to check on the values in that field, with that in mind I need to build a formula that checks for nulls yet still compares the value I'm looking for.

IF ({table.field}) = "xx"
Then 1
Else 0
0
 

Author Closing Comment

by:Roberto Madro R.
ID: 38852840
To get around this problem, I wrapped an "if isnull" statement around my formula (see above) and it worked fine

IF ISNULL (Sum ({@CountXX}, {Table.Field}))
Then 0
Else Sum ({@CountXX}, {Table.Field})
0

Featured Post

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question