% Of a field

[KeertanaCR]

Hi All,

I have a report which is grouped by a field A. In this report i have a field B ( count of C calculated from Stored Proc). I need another field in the report which should be
% of B for each record. Which Means % of B ( with the total B)

So, I write a formula (B/sum(B,A))*100 to get the %of B.
Now I also need count of this % of B field.

Any ideas to solve this issue.

Thanks for ur help

Keertana

 

[lbass]

Please show some sample data. What do you mean by:

I also need count of this % of B field.

...since the count of the % of B will the same as the count of any field in the group. Do you mean you want to group and count by the value of % of B?

-LB

 

[KeertanaCR]

Sorry Sorry,

I need sum of this %of B field

Thank you
Mamata

 

[lbass]

Well, but the sum of B % of sum(B,A) will always be 100% at the A group level--no need to calculate.

-LB

 

[KeertanaCR]

Thank you.