Customer Count

[former_member221192]

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

[Former Member]

Hi Ganapathy,

By looking into your variables, it seems like you are using Universe based on cube.

Seeing your criteria and explanation, it is evident that [Leave].[L01 Cal. year / month]=[v_leavesummary month] condition should get satisfied as values are available.

Can you also drag [OD data] object in the report and check if it is not giving 0? Else it will not fulfil the AND condition.

Also drag both [Leave].[L01 Cal. year / month] and [v_leavesummary month] objects in a vertical table and add another column with formula =If( [Leave].[L01 Cal. year / month]=[v_leavesummary month]) Then 1 Else 0 and check if it is returning 1 for 09.2013 value or not.

May be it can help in some ways.

Regards,

Yuvraj

[former_member221192]

it is fulfilling the condition,even giving 1 value