Hello All,

I have output like,

A B Total

C1 C1 C2 % C1 C2 % C1 c2 %
art 2 4 50 3 6 50 5 10 100

When i sum the cloumn total am getting percentage as 100% instead of 50%.

Can you help me

Thanks and Regards,

quote:

C1 C1 C2 % C1 C2 % C1 c2 %
art 2 4 50 3 6 50 5 10 100

When i sum the cloumn total am getting percentage as 100% instead of 50%.

Have you tried ON TABLE SUMMARIZE

It should recalculate for you.

Unfortunately, I don't think you can get PCT to recalculate when used in an ACROSS-TOTAL or ROW-TOTAL. You would assume it should work automatcally, but no.

Doesn't work:

DEFINE FILE CAR
SALESD/D15 = SALES;
END

TABLE FILE CAR
SUM
SALESD
PCT.SALESD/D6.2% 
BY COUNTRY 
ACROSS SEATS
ACROSS-TOTAL
ON TABLE SUMMARIZE
END

Workaround, using a two-verb request:

DEFINE FILE CAR
SALESD/D15 = SALES;
END

TABLE FILE CAR
SUM
SALESD AS 'TOTAL,SALES'
PCT.SALESD/D6.2% AS '%'
BY COUNTRY 
SUM
SALESD AS 'SALES'
PCT.SALESD/D6.2% AS '%'
BY COUNTRY 
ACROSS SEATS
ON TABLE SUMMARIZE
END

Francis

I see you have this great solution.
I played a bit with it and have the following addition, since we want the sum ad the end and not ad the beginning we did this

DEFINE FILE CAR
SALESD/D15 = SALES;
SALESX/D15=SALES;
END
TABLE FILE CAR
SUM
     SALESX NOPRINT
     PCT.SALESX/D6.2% NOPRINT
BY COUNTRY
SUM
     SALESD AS 'SALES'
     PCT.SALESD/D6.2% AS '%'
BY COUNTRY
ACROSS SEATS AS ''
     COMPUTE
          TOTSALES/D12.2 = SALESX;
     COMPUTE
          TOTPERC/D6.2% = PCT.SALESX;

Frank, that's quite interesting. Thanks for your example.

Thanks everyine for the input. I am getting the required report.

Thanks