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

null
    • Raphael_Vieira_de_Matos
    • 5 yrs ago
    • Reported - view

    I think I have the answer : cnt(ENFANTS[SEXE = 1])

Content aside

  • 5 yrs agoLast active
  • 1Replies
  • 1076Views