Counting portal entries - modified

[Ponderosa]

Is there a way to count the number of records in a portal (got that part figured out in a sum field) AND account for if a record has a specific field entry?

I have a portal that displays games and sometimes the games are paired together in one record. I want to be able to count the paired games as 2, not 1. I'm thinking something like If ( Qty = 2 ; ( Get ( TotalRecordCount) * 2 ) ; 1 ), but currently what I get is ALL the records, times 2.

[Agnes Riley]

Is it a filtered portal or not?

If it's not filtered, this is pretty simple. You can get a count of Ids from the parent table: Count ( your portal::iD ).

If it's a filtered portal, you'll need to duplicate that portal and just show one record in the duplicated portal. Create a summary field in your child table of the record Ids. Put that in your filtered portal copy. Make sure the filtering matches the original portal.

[Fitch]

Why not Sum( related::Qty ) ?

[Agnes Riley]

Does the "qty "indicated 2 for a paired game? Cause if yes, then Fitch's answer is the correct one for an unfiltered portal.

[Ponderosa]

Got it! Thanks