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?  
LVL 2
rvfowler2Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
FileMaker Pro

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.