Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 207
  • 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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
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

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

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