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..