Count of Customer is zero(0)

[former_member221192]

Hi,

this is my formula,showing zero values,actual  customer count is 41

=Count([v_Customerkey]Where([CY MTD Bud Val]>0 And [Main Query].[Business Line]="HPC" And [L01 Industry Code 1]="Chem-Applicators" Or [L01 Industry Code 1]="Chem-Fabricator")ForEach([v_Customerkey]))

in this above formula Customer key detail object, Created dimension variable (i.e)  [v_Customerkey]

[v_Customerkey]

     =[L01 Customer Key]

plz help me..plz find the attached snap shot

[former_member221192 · Accepted solution]

Hi,

first i have filter the customer using following formula,,

V_Apcat & fabricat Cust

     =[L01 Customer Key]Where( [Main Query].[Business Line]="HPC" And [L01 Industry Code1]="Chem-Applicators" Or

       [L01 Industry Code 1]="Chem-Fabricator")

     again i took count of customer with following condition,this is giving correct count

        =Count([V_Apcat & fabricat Cust] Where([CY MTD Bud Val]>0))

thank you, for all your quick response..

[Former Member]

Hi,

maybe try something like:

create dimension:

COUNT_DIM = if([CY MTD Bud Val]>0 And [Main Query].[Business Line]="HPC" And

([L01 Industry Code 1]="Chem-Applicators" Or [L01 Industry Code 1]="Chem-Fabricator")) then 1 else 0

create measure:

COUNT = Count([v_Customerkey]Where( [COUNT_DIM] = 1 )

otherwise I would try to start first only with "where ([CY MTD Bud Val]>0)" and add one restriction by one to see when it becomes zero.

HTH,

Andreas

[former_member221192]

there is no value,empty it is showing

[Former Member]

Try the formula below ... You are also missing a Parenthesis for the Or in your formula

Also looks like you are counting and showing in a single cell so you would not need ForEach([v_Customerkey]))

=Count([v_Customerkey]Where([CY MTD Bud Val]>0 And [Main Query].[Business Line]="HPC" And ( [L01 Industry Code 1]="Chem-Applicators" Or [L01 Industry Code 1]="Chem-Fabricator")) in Report

[former_member221192]

Hi,

this formula also showing zero values.

=Count([v_Customerkey]Where([CY MTD Bud Val]>0 And [Main Query].[Business Line]="HPC" And ( [L01 Industry Code 1]="Chem-Applicators" Or [L01 Industry Code 1]="Chem-Fabricator"))In Report)

[Former Member]

Hi,

It Should be ForAll

=Count([v_Customerkey]Where([CY MTD Bud Val]>0 And [Main Query].[Business Line]="HPC" And [L01 Industry Code 1]="Chem-Applicators" Or [L01 Industry Code 1]="Chem-Fabricator")ForAll([v_Customerkey]))

Thanks,

Kirthi

[former_member221192]

again showing 0 values

[Former Member]

Hi,

Try below,

=Count([v_Customerkey]) Where([CY MTD Bud Val]>0 And [Main Query].[Business Line]="HPC" And ([L01 Industry Code 1]="Chem-Applicators" Or [L01 Industry Code 1]="Chem-Fabricator"))ForAll([v_Customerkey]

Thanks,

Kirthi