%%%%%

[Former Member]

I want to divide the individual customer count at a particular level by the overall customer count, then I created another variable called Overall Customer Count with the formula of the variable something like this:

Code:

Individual Count = Count( [Customer Identity]) ForEach([Service Provider])

Code:

Overall Customer Count =count([Customer Identity]) in Report

Then I want to calculate the%% = (Individual Count/Overall Customer Count) * 100

Issue : % is still considering the sum of the Individual count in table instead of Overall count in the report.

The acutal count of Customer ID is 1566

Service Area ( Section)

Provider | Count of customer ID

USAA 116

RAR 80

TRE 96

Now I need %% >>>> (116/1566)100*

Provider| Count of Customer | %%%

USAA 116 7

RAR 80 5

TRE 96 6

Issue is considering the total of ( 1168096) = 296 >>>>>> (116/296)100*

I need to consider the overall total.

Please help me out........

Edited by: reddy1868 on Oct 21, 2010 1:44 AM

[Former Member]

Change your Overall Customer Count by getting rid of the ForALL(Service Provider) and moving the in report inside the count parentheses:

Code:

=count([Customer Identity] in Report)

If a customer can be in more than one service provider change the formula to:

Code:

=count([Customer Identity] in Report;All)

[Former Member]

Try this:

Individual Count = Count( Customer Identity) ForEach(Service Provider)

Overall Customer Count =count(Customer Identity) ForALL(Service Provider) in Report

%% = (Individual Count/Overall Customer Count) * 100

Gracias...!!

[Former Member]

Individual Count = Count( Customer Identity) ForEach(Service Provider)

Overall Customer Count =count(Customer Identity) ForALL(Service Provider) in Report

%% = (Individual Count/Overall Customer Count) * 100

Everything looks Ok But when I am using the %%%% in the block, It is still considering the %%% for the block.

For example : If the Count of Customer Identity in the Block is 809. But the overall Count of Customer Identity is 1446.

When I am calculating %%% , (Individual Count/Count of Block Customer Count) * 100

Any suggestions.