count pass/fail students in pivot table

[Anonymous]

maverjannet‌bunnyqlik‌ MarcoWedel‌

this is live example for count pass/fail students..

i need to count the failed students in pivot table like the example

regards.

[Anonymous]

It's work thanks

what about [ Passed all unit] i try to use this two expression but it's all wrong >>

=if(Pass_Fail <> 'F',count( Pass_Fail))

=count(DISTINCT if(PASS_FAIL <> 'F', People_ID))

Regard.

[rubenmarin]

Hi Mohammed, maybe with:

count(DISTINCT People_ID)-count(DISTINCT{<PASS_FAIL = {'F'}>} People_ID)

Or:

count(DISTINCT People_ID)-count(DISTINCT if(PASS_FAIL <> 'F', People_ID))

If it can be people_Id without evalutions you should filter those:

count(DISTINCT{<PASS_FAIL = {'F','P'}>} People_ID)-count(DISTINCT{<PASS_FAIL = {'F'}>} People_ID)

[#4]

if i was you i would use:

Count(distinct if((Aggr(sum(if(PASS_FAIL = 'F',1,0)), People_ID))=0,People_ID,0))

The reason being, we want to calculate this over People_ID. Hope that makes sense.

Regards

RL

[Anonymous]

Hi,

There at total it should be passed + Failed.

Because there are some records which are not either comes under Passed or Failed.

Thanks,

Bunny