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

FM - Can't get a Rec to Show Up in a Portal Whose Total is Zero

Cannot get a record to show up in a portal.  I have a summary table of banks and one of them has 0 for the current year.  I made sure my calculation would display a 0 instead of a blank in the field, but it still doesn't show up.  Any suggestions?
0
rvfowler2
Asked:
rvfowler2
  • 4
  • 3
1 Solution
 
Will LovingPresidentCommented:
So you want the field to actually show 0 for the year?  Make sure that it's a Number field or result and that the formatting for the field is set so that "Do not display if zero is unchecked" on the Inspector, Data Tab, Number Formatting.
0
 
rvfowler2Author Commented:
I did that, but it is still not showing up in the portal.  See attached.  (And no filters in the portal).
Capture4.JPG
0
 
Will LovingPresidentCommented:
I'm assuming your calculation says something like, If( A - B = 0 ; "0" ; A - B )

Make sure the check box at the bottom of the calculation is checked. Make sure the "Do not evaluate if all referenced fields are empty" option is unchecked.

Do not evaluate...
0
Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

 
rvfowler2Author Commented:
"Make sure the check box at the bottom of the calculation is checked."  Which check box?  On your other point, went through and unchecked "Do not evaluate...", but still not showing in portal.
0
 
Will LovingPresidentCommented:
I was referring to the "Do not evaluate…." checkbox
0
 
Will LovingPresidentCommented:
I'm guessing that the relationship you are using for the portal is somehow excluding the record that bank record that has zero. Either because of the zero, meaning no data to display, or because that bank record isn't valid in the relationship.
0
 
rvfowler2Author Commented:
Yes, I was using the wrong TO by mistake, the one I used to calculate the summary fields for the current year.  Used an X relationship table in the portal and it appeared.  Thanks, Will.
0
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.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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