Coalesce function is not working

[raquelchaicoj]

hello @Kal_Lam, I am working in two project, the first one is the parent form and is an enrollment form which collects information about the participants who will be part of a program.
The child form is an attendance sheet that reports the number of participants in a community. in the child form, at the end I have generated variables to add up the number of female and male participants, for this I have used the functions:

coalesce(${Sexo_G1_mujer}, 0)+ coalesce(${Sexo_G2_mujer}, 0)+coalesce(${Sexo_G3_mujer}, 0)+ coalesce(${Sexo_G4_mujer}, 0)+ coalesce(${Sexo_G5_mujer}, 0)
coalesce(${Sexo_G1_hombre}, 0)+ coalesce(${Sexo_G2_hombre}, 0)+ coalesce(${Sexo_G3_hombre}, 0)+ coalesce(${Sexo_G4_hombre}, 0)+ coalesce(${Sexo_G5_hombre}, 0)
${mujeres_talleres}+${hombres_talleres}

when tested, it does work well for women, however, it does not generate information about the male participants. I have checked, and I don’t know what could be wrong.

I would appreciate your help.
I share with you the forms
Parent form:
FORMULARIO PADRE INSCRIPCION.xlsx (26.3 KB)

child form
FICHA REGISTRO CAPACITACIONES, TALLERES U OTRAS ACTIVIDADES.xlsx (27.5 KB)

If you need access, please let me know.

I will appreciate if any one of the @ambassadors can support, will be great.

Greetings!

[osmanburcu]

Hi @raquelchaicoj, were you able to solve your problem? because i checked your form and it looks like working fine.

[raquelchaicoj]

Hello Osman, I try once but still not working

if it is need it, I can share permission to the project forms. or we can have some zoom meeting.

Thank you very much for your time

[osmanburcu]

if you can share the both form with username osmanislamburcu , i can can test

[wroos]

Could you try to strip down the form to a short example, still reproducing your error.
I tried a minimal extract with manual entry. It seems to show that the coalesce and it’s input calculations are not the problem.
wroExtract01_FICHA_REGISTRO.xlsx (10.9 KB)

Side-note: Select-values are always stored as strings, so better use if(${Sexo_G4} = ‘1’, 1, 0). And better avoid blanks and special characters in file names.