Quick!! Portal Found Count???

[SoCalMacDude]

In FM 8.5, I can't figure out how to show the number of portal records found. I just want a count of the related records!

[dharlow]

Create a calc field with Count (related_field)

Daniel

[Søren Dyhr]

Stuff Count from the aggregate functions into a calc'field, not to be confused with the Summary function. But you need to count on the foreign ID in case empty fields otherwise might exists. ValueCount(List( the same field will produce similar results ...but the important issue here is that the calc'field needs to be unstored - perhaps is the new option faster?

--sd

[SoCalMacDude]

Thanks, guys!

I ended up creating a calc field in the related table that = 1, then SUM that field.

(That was before I got any replies!)

Works like a charm!

[Ender]

I ended up creating a calc field in the related table that = 1, then SUM that field.

I'd recommend you switch to dharlow's solution. count() is more efficient than sum() for this, and doesn't require a separate calc to count in the child table.

[Søren Dyhr]

Indeed it seems pretty weird to bloat a solution with redundance, may we hear some kind of defence for this disposition???

--sd

[SoCalMacDude]

Agreed, guys!

My defense is found in the first word . . . "Quick!"

You see, I was at a customer, and could not figure out how to do it - so after searching FM help, this forum and coming up empty, I posted, hoping for a quick response - I figured it was such a simple thing that anyone perusing this portal forum would know it and drop me a hint!

I know, a high expectation to get an answer so soon after posting, but worth a try!

As you can see, the first response was 10 hours later - I was sleeping then, 50 miles away from the database! So, that is my only defense for the slopy, inefficient, redundancy, and I will use dharlow's "Create a calc field with Count (related_field)" when I get in front of that database again.

If only that answer came 9 hours earlier -)) !!

Thanks for your concern, everyone!