Skip to Content
0
Oct 26, 2013 at 05:02 AM

Customer Count

32 Views

Hi,

current month Count of customer this is my formula

=If(Sum([OD data])>0 And [Leave].[L01 Cal. year / month]=[v_leavesummary month];1;0)ForEach([Customer Key (Deco Sales Base Query New)];[Leave].[L01 Cal. year / month])

V_leavesummary month=09.2013 this is my current month

L01 Cal. year / month]=04.2013

06.2013

07.2013

08.2013

09.2013

if i drag that variable 0(zero) values showing ,actually customer count is 4543