AnsweredAssumed Answered

In a filter portal on Parents, how to sum a field of (filtered!) Children?

Question asked by edyas on Jul 8, 2018
Latest reply on Jul 11, 2018 by beverly

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.