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.
In the case of the paired games, is there a "primary" part and a secondary/subsidiary part?
If so, you could add a field that indicates the second record is "secondary" or something to that effect.
Then make a Calculation field set to something like "If(secondary_flag="secondary",0,1) Create a sum that runs on this calculated field.
Kind regards,
Lee