April 28, 2006, 01:50 PM
Spenceadd the BY CAR after the first verb in j.g. solution and it works fine.
TABLE FILE CAR
SUM DEALER_COST NOPRINT
BY CAR
SUM DEALER_COST RETAIL_COST
BY CAR
ACROSS COUNTRY
RECAP DC_TOTAL=C1;
END
April 28, 2006, 01:58 PM
KameshHi JG and Spence,
Yes, this code works but I want the label to say as Total, Dealer, Cost.
Example:
TABLE FILE CAR
SUM DEALER_COST NOPRINT
BY CAR
SUM DEALER_COST RETAIL_COST
BY CAR
ACROSS COUNTRY
RECAP DC_TOTAL=C1; AS 'Total, Dealer, Cost'
END
The problem is, it is displaying Total Dealer Cost in one line. The comma is not working as how it works in Title(start in next line).
April 28, 2006, 02:20 PM
LeahI just ran the code in our windows 5.3.4 and the title for the DC_TOTAL came out as three lines. Moment here, it is not removing the comma is what you're saying? I ran without the commas to HTML out and it wrapped the header but then that may be due to html.
April 28, 2006, 02:23 PM
Spencequote:
DC_TOTAL
try this.
TABLE FILE CAR
SUM DEALER_COST NOPRINT
BY CAR
SUM DEALER_COST RETAIL_COST
BY CAR
ACROSS COUNTRY
RECAP 'Total Dealer Cost'=C1;
END
January 26, 2010, 04:34 PM
KrystiHi,
I used this solution because I didn't need a row total for all my across columns.
Worked great so thank you!
Now the problem...
At first, all the RECAPs were printing 2 decimals even if the original columns were not formatted that way. Then, I had to change the format of some of the columns so the $ would print. Now, my RECAP totals are size 10 font instead of size 8 like the rest of my columns (only the data, the titles are fine).
I've tried referring to them by Cn and by the field name. No dice. Any ideas?
Thanks,
Krysti
January 26, 2010, 04:46 PM
KrystiNevermind. I got it to work.
I added a format to the RECAPs and it picked up the size 8 font. No idea why, but it did!