Hi everyone, I have met a disturbingly hard-to-digest stone, at least to my taste.
I have set up 2 filtered portals for Parents and Children, which work fine: only the relevant Parents and Children are respectively displayed.
In the Children Portal, I have a number field (Occurrences:oc_count).
What I want: in the Parents Portal, create a field that would sum that very field (Occurrences:oc_count) but only for the filtered Children, and not for all Children. To complicate further, I need a sum of related children for each parent, and not one global sum of all related children.
I have tried Summary fields, Calculation fields based on Sum, to no avail.
I'd be very grateful for any assistance on this.