how can i count numbers in a dependency of a other column?

[#1]

Hello together,

I have a problem. This is my table

Numbers	division
12345	-
12346	23
43234	43
34565	-
87654	45

How can I count the Numbers with the numbers (23,43,45) in the division.

The result must be 3 (23, 43,45)

Do you have a solution for me.

Thank you.

[preminqlik]

hi there,

try this

count(distinct if(isnull(division)=0,Numbers)

[MayilVahanan]

HI

Try like this

Numbers in dimension

=Count(Distinct division) // use suppress null values.

Division as dimension

=Count({<Division = {'*'}>}Numbers)

[#4]

It doesn't work. The formula shows only - in the column.

Do you have a other solution.

Thank you.

[#5]

Hi,

If the Division holds only numaric then you just try with below

Count({<Division -= {'$(=Null())'}>} Division) 

                    (or)

Count({<Division =  {'>0'}>} Division)

[#6 · Accepted solution]

Hi

use this expression it works

Count(if(division>0,numbers))

[#7]

Hi,

please try this:

count(if(division='23' or division='43' or division='45',Numbers));

Kind Regard

[preminqlik]

hey try this

count(distinct if(isnull(division)<>-1,Numbers)