Skip to Content
0
Former Member
Sep 21, 2005 at 07:39 PM

SUMCT Result Problems

26 Views

Hi,

I am trying to get the total number of lines for the result to appear on each line of the report based on the drill level. I created formula1 that uses a keyfig. In formula1 I use SUMCT with keyfig and it has no effect on each individual line and it gives me the Overall Result instead of Result. I am wanting 5 to appear in each line below but the individual lines come out the same as the original keyfig and the Result line shows as the Overall Result in this case 10.

In formula2 I use the SUMGT with keyfig and it gives me 10 for every line and not 5.

How can I get the 5 to appear?

Material Customer keyfig formula1 formula2

-


-


-


-


-


A A 3 3 10

B 2 2 10

C 2 2 10

D 2 2 10

E 1 1 10

Result 5 10 10

B A 3 3 10

B 2 2 10

C 2 2 10

D 2 2 10

E 1 1 10

Result 5 10 10

Overall Result 10 10 10

Thanks

Eric