count if...

[anitamanders]

Hello,

I have a pivot table with a column (1) that loads (sum sales - sum target)

Now I want to count all customernames where column (1) < 0  (so where sales < target)

I have tried this:

Count (DISTINCT(if(Column(1)= '<=0',[organisatie_naamorg])))

but this results in 0 for everything, so I am doing something wrong....

Can someone help me with this?

Thanks!

[tresesco]

Try: Column(1)<=0

instead of

Column(1)= '<=0'

[#3]

try this

Count (DISTINCT(if(Column(1)<=0,[organisatie_naamorg])))

[anitamanders]

no, does not work

[Anonymous · Accepted solution]

Hi Anita,

     Hope the attached file will helpful for you

Regards

Ashok

[narender123]

Hi

Try this,

=if(Column(1)<=0,Count(Distinct [organisatie_naamorg]))

Thanks.

[anitamanders]

thanks a lot Ashok, this works perfectly !!

[Anonymous]

     Great.

     welcome

Regards

Ashok

[#9]

Hello Anita,

if you just want to display the number of customers who didn't get the target, then I wonder if the function below helps :

=count(aggr( if( Sales < Target, Name ), Name ))

You could use a text object to test the function ( after you replaced the fields names with yours ofcourse ).

Hope this helps....