0
formula and filter
Hello,
I have two tables : parent and children.
In parents, I would like to get a formula to compute the number of children (male/female).
To compute the number of children from parent, I use : cnt(ENFANTS.SEXE). It works properly.
My problem begins, when I begin to try the number of male or female linked to this parent. I used the following script : count((select 'CANDIDAT - ENFANT')[number(SEXE) = "1"]) . But this returns the entire number of male or female children, not the number of male or female children linked to the parent.
What is wrong ?
Best regards,
1 reply
-
I think I have the answer : cnt(ENFANTS[SEXE = 1])
Content aside
- 5 yrs agoLast active
- 1Replies
- 1076Views