• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 549
  • Last Modified:

FM - What's the Simplest Way to Show 0 Instead of Blank for the Summary Count field of a Filtered Field?

I can think of several ways of doing this, but what is the standard or simplest way of rendering the blank null value as "0" when using a Summary Count of a filtered field which has zero records?  
0
rvfowler2
Asked:
rvfowler2
  • 5
  • 4
  • 2
4 Solutions
 
rvfowler2Author Commented:
0
 
Will LovingPresidentCommented:
Maybe I'm not fully understanding you but I would think that as long as the number formatting on the layout is correct and the "Do Not Display Number if Zero" checkbox is NOT checked, then it should show as zero. Do you mean that the CountNewsday value is null and/or that the Count of CountNewsday has not records? It shouldn't really make difference since I believe Count only count's non-null values.
0
 
rvfowler2Author Commented:
Summary fields don't have this, but unchecked all "Do not evaluate if all referenced fields are empty in the calculated "filtered" field.  See attached for portal that shows blanks instead of 0 in some places.  
--ShowingZero.JPG
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
ThomDrozCommented:
Just a quick look, I did not test this but ...
did you try putting a text of "0" on the form with conditional formatting to only show if "isempty"?
0
 
Will LovingPresidentCommented:
Without an example file so I know exactly what you are doing, it's a little hard to test this. To clarify, the five columns after the % symbol are summary fields? Looking at it I would assume that they were calculation fields. I don't think I've ever put Summary fields in a Portal, though I have used Get Summary [] calculations. Can you provide an example file?
0
 
rvfowler2Author Commented:
Figured it out, but giving credit as you guys pointed me in the right direction.  Will, yes the fields were calc fields, but as you see in the attachment, they were pulling in summary fields.  What I did was pull the summary fields from Leads into a calc field in Properties, then bring it back to leads in a portal.  This allowed me to place it in a Trailing Grand Summary in a report, as well as place info from two different tables into the same portal!

Below is the calc that worked - I guess you need it when pulling in summary fields.  However, turns out it was a moot point because my boss ends up preferring a 0 not showing as it clutters up the portal rows.  This way his eye can be quickly drawn to the property rows that actually do have data in them.

If ( LeadsbyDateRange::TotalOther = ""; 0; LeadsbyDateRange::TotalOther )
--ShowingZero2.JPG
0
 
rvfowler2Author Commented:
Also, thanks Thom for the reference to showing 0.  Though I didn't use conditional formatting, it reminded me of how to do it via the calc box in the field.
0
 
Will LovingPresidentCommented:
Hey Randy, just noting again that when you give yourself credit, even if you don't assign points, it handles it differently - generating a "close request" - rather than just marking the accepted answers. This also means, I think that a moderator might have to look at it which is probably just extra work for them. I understand why you are doing it - acknowledging your own contribution to the solution - but it does seem to change how the question is closed....
0
 
rvfowler2Author Commented:
Yes, but I want to make sure whoever reads this in the future, can easily see the right answer by just browsing through the answers that are checked.  I don't like it; if I give myself 0 points, it should go through automatically.
0
 
ThomDrozCommented:
rvfowler
I agree with you, the issue is with experts exchange.  
The other option is to write out your solution in your final reply, then anyone who reads it later can read what you said.  
0
 
Will LovingPresidentCommented:
when I read through a solution, I usually read the whole thing anyway, not just the "Accepted Answer", because you have to understand the whole context of what is being talked about.
0

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

  • 5
  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now