Hi

I need count the different values of a select, i have a principale table "Event" with a composition table "temps", in the table table "temps"i have a row " climat" type select, and i want count for a row "Event" how many row i have with the value 3.

i make a formula and this formula return the total for all Event row.

let myID := number(ID);
let myTemps := Temps;
if Temps then
cnt((select Temps)[Climat = 3])
else
0
end

i search to add the conditions with same Event.id but dont works the value return 0

let myID := number(ID);
let myTemps := Temps;
let tID := Temps.Event.ID;
if Temps then
cnt((select Temps)[Climat = 3 and myID = tID])
else
0
end

what is the right code to use?

thank you