[SOLVED] Recompute formatting

Hi,
I need to format the fields that use the recompute in it.
My existing code is -
BY COUNTRY NOPRINT
ON COUNTRY RECOMPUTE
AVE. COST AS 'Status by Div '
ON TABLE RECOMPUTE
AVE. COST AS 'Status for All '

I need to have a grey line for 'Status By Div'
and 'Status for All'. How do i get grey bars for these?

I have used-
TYPE=SUBTOTAL,
BY=1,
STYLE=BOLD,
BACKCOLOR='GRAY',
COLOR = 'WHITE',
$

The gray bars are only coming for 'Status By Div' and not for 'Status for All'

1) How do i get the gray lines to both?
2) Also, how do i fix the position of 'country' and the a'verage of cost' under column 3 and 8 respectively?

Please suggest.

This message has been edited. Last edited by: Kerry,

<JG>

posted

quote:
BY=1,

You are specifically telling it to do the styling on the BY=1.

ON TABLE RECOMPUTE is referenced by TYPE=GRANDTOTAL

TYPE=GRANDTOTAL,
BACKCOLOR=PINK,
STYLE=BOLD,
$

<B_B>

posted

Hi JG,

Thanks for your response.

I did use the below code and it worked fine by producing grey bars correctly.
TYPE=GRANDTOTAL,
BACKCOLOR=GRAY,
STYLE=BOLD,
$

However , i am facing issues to align it in one straight row. I need the text to come as
"Status by Div 100 92.27%"

But, i am getting it like
Status by Div 100 92.27%.

How do i arrange the numbers i.e. 100 and 92.27%
at different positions as i desire(e.g. 100 should come under column 3 and 92.27% should come under column 8) ?

<JG>

posted

B_B

Unfortunately what you want looks exactly like what you have,
you need to use code tags to keep the spacing

 Status by Div                      100                          92.27%

RECOMPUTE gives you no control over positioning and always places to value under the column
to which they logically belong

For what you want you need to use RECAP and SUBFOOT with spot markers and the HEADALIGN attribute in the stylesheet

 TABLE FILE CAR
SUM DEALER_COST RETAIL_COST
COMPUTE PP/D12.2%=(DEALER_COST/RETAIL_COST)*100;
BY COUNTRY 
BY CAR
BY MODEL
ON COUNTRY RECAP PPX/D12.2%=(DEALER_COST/RETAIL_COST)*100;
ON COUNTRY SUBFOOT
" COUNTRY NO HEADALIGN <COUNTRY <+0> <PPX <+0> <+0> <+0>"
ON TABLE RECAP PPY/D12.2%=(DEALER_COST/RETAIL_COST)*100;
ON TABLE SUBFOOT
"TOTAL ALL COUNTRIES HEADALIGN<+0> <PPY <+0> <+0> <+0>"
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
TYPE=SUBFOOT, STYLE=BOLD,BACKCOLOR=GRAY,COLOR = 'WHITE',$
TYPE= TABFOOTING, HEADALIGN=BODY,BACKCOLOR=GRAY,STYLE=BOLD,$
ENDSTYLE
END

This message has been edited. Last edited by: <JG>,

<B_B>

posted

Hi JG,

The solution of using two RECAP commands helps in formatting, but in the code -
TABLE FILE CAR
SUM DEALER_COST RETAIL_COST
COMPUTE PP/D12.2%=(DEALER_COST/RETAIL_COST)*100;
BY COUNTRY NOPRINT
ON COUNTRY RECAP PPX/D12.2%=(DEALER_COST/RETAIL_COST)*100;
ON COUNTRY SUBFOOT
" COUNTRY NO HEADALIGN <+0>"
ON TABLE RECAP PPY/D12.2%=(DEALER_COST/RETAIL_COST)*100;
ON TABLE SUBFOOT
"TOTAL ALL COUNTRIES HEADALIGN<+0> <+0>"
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
TYPE=SUBFOOT, STYLE=BOLD,BACKCOLOR=GRAY,COLOR = 'WHITE',$
TYPE= TABFOOTING,HEADALIGN=BODY, BACKCOLOR=GRAY,STYLE=BOLD,$
ENDSTYLE
END

How do i get rid of the value 84.29% for 'TOTAL ALL COUNTRIES HEADALIGN' ?

In the last line i need to calculate the final average...but, here it is picking up the last value from "COUNTRY NO HEADALIGN"

My aim is to calculate the average of 'DEALER_COST by DIV' first and in the end i need to calulate the average of the entire DEALER_COST and display it in the end.

<B_B>

posted

Hi JG,

I fix the issue.

Thanks for your help.

I used 2 By fields for RECAL command.

Please Wait. Your request is being processed...

Read-Only Topic

Focal Point

Focal Point Forums

WebFOCUS/FOCUS Forum on Focal Point

[SOLVED] Recompute formatting

Focal Point | Privacy Statement | Terms of Service