Skip to Content
0
Dec 09, 2013 at 10:39 AM

Count of Customer is zero(0)

18 Views

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

Attachments

Count.JPG (177.8 kB)