Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm not sure if I'm just missing something.
I trying to count , in this case the number of suppliers when two expressions match. Basically if the supplier scores 100% I would like to count him and in the end I'll see howmany suppliers score 100% out of a total,
appreciate the help
count(
{<
=count({<Logische_Controle_TXT={'GOED'}>}DISTINCT Child_id)
=count(DISTINCT Child_id)
>}
[leve-ki]
Perhaps like this:
count({<[leve-ki]={"=count({<Logische_Controle_TXT={'GOED'}>}DISTINCT Child_id)=count(DISTINCT Child_id)"}>}[leve-ki])
I think the only way is
Count(if(count({<Logische_Controle_TXT={'GOED'}>}DISTINCT Child_id) = count(DISTINCT Child_id), [leve-ki], 0)
hope it helps
Unfortunateky thi does not work.
any other sugestions?
and this?
if(count({<Logische_Controle_TXT={'GOED'}>}DISTINCT Child_id) = count(DISTINCT Child_id), Count([leve-ki]), 0)
Perhaps like this:
count({<[leve-ki]={"=count({<Logische_Controle_TXT={'GOED'}>}DISTINCT Child_id)=count(DISTINCT Child_id)"}>}[leve-ki])
when adding distinct it works
count({<[leve-ki]={"=count({<Logische_Controle_TXT={'GOED'}>}DISTINCT Child_id)=count(DISTINCT Child_id)"}>}DISTINCT [leve-ki])
Thanks!
Could you explain why you add the part [leve-ki]= in front of the set analysis
You always have to have a field name on the left side of the = sign. It means "I want to restrict the set to those values of leve-ki where count(...foo...) equals count(...bar...)"