I am using a subfoot containing TOT.SELLSvalue and TOT.COSTvalue and would like to use a recap to find out the percent profit and keep it in the same row just one column to the left.

Does anyone know how to do this?

I tried to do a recap and use noprint but it gives me an error

Any Ideas?

This message has been edited. Last edited by: Charles Richards,

pls post the code you have created
it might help to solve this.

RECAP creates temporary fields on the BY field level the RECAP is coded for.
You can't specify NOPRINT for a RECAP field. In stead you have to use a subfoot on the same BY level. In the subfoot you can name the recap field or not. If you do not mention it in the subfoot, it won't show. Furthermore you will have to do the positioning of the fiels in the subfoot yourself, nothing automated there.
And as Frank states - the ability to view the code aleready in place helps to better advise you.

TABLE FILE DETAIL
SUM
totCost NOPRINT
totSRP NOPRINT
totbydepcase NOPRINT
BY IN_DEPARTMENT NOPRINT
SUM
subtotcost NOPRINT
subtotSRP NOPRINT
subTotalProfit NOPRINT
BY IN_DEPARTMENT NOPRINT
BY IN_COMCLASS NOPRINT
SUM
AVE.IN_ITEMCODE/I7 AS 'ItemCode'
IN_COMCLASS AS 'CC'
IN_DESC AS 'Item Description'
AVE.IN_PACK AS 'Pack'
IN_SIZE AS 'Size'
CaseDel AS 'Cases Del.'
F_Time AS 'Time Del.'
UnitMove AS 'Unit Move'
totCost AS 'Total Amount Paid'
totSRP AS 'Total Sell Value'
AVE.PercProf AS '% Profit'
TotalProfit
COMPUTE PCTTOT/D9.2 = ( totCost / subtotcost ) * 100;
AS '% Sales @ Cost'
COMPUTE PCTSRP/D9.2 = ( totSRP / subtotSRP ) * 100; AS '% Sales @ Sell'
COMPUTE PCTPRO/D9.2 = ( TotalProfit / subTotalProfit ) * 100;
AS 'Dol Profit'
COMPUTE PCTBYDEPC/D12.2 = subtotcost / C1 * 100; NOPRINT
COMPUTE PCTBYDEPS/D12.2 = totSRP * 100;
COMPUTE PCTBYDEPCA/D12.2 = subtotcase / C3 * 100;
BY IN_DEPARTMENT NOPRINT
BY IN_COMCLASS NOPRINT
BY TOTAL HIGHEST COMPUTE PCTPRO/D9.2 = ( TotalProfit / subTotalProfit ) * 100; NOPRINT
BY IN_ITEMCODE NOPRINT

ON IN_DEPARTMENT SUBTOTAL
TotalProfit
CaseDel
totCost
totSRP

ON IN_COMCLASS RECAP
SubPercProf/D12.2 = 2 + 2;
ON IN_COMCLASS SUBFOOT
" "
"&|nbsp; &|nbsp;&|nbsp;&|nbsp; &|nbsp;&|nbsp; &|nbsp;&|nbsp;&|nbsp;&|nbsp;&|nbsp;&|nbsp;&|nbsp;&|nbsp; TOTAL &|nbsp; &|nbsp;&|nbsp;&|nbsp; &|nbsp;&|nbsp; &|nbsp;&|nbsp;&|nbsp;&|nbsp;&|nbsp;&|nbsp;&|nbsp;&|nbsp;&|nbsp; &|nbsp; % TOT. &|nbsp; &|nbsp;&|nbsp;&|nbsp;&|nbsp;&|nbsp;&|nbsp;&|nbsp; &|nbsp;&|nbsp;&|nbsp; TOTAL SALES &|nbsp; &|nbsp;&|nbsp;&|nbsp;&|nbsp; &|nbsp;&|nbsp;&|nbsp;&|nbsp;&|nbsp;&|nbsp; &|nbsp;&|nbsp;&|nbsp; % SALES &|nbsp; &|nbsp;&|nbsp; &|nbsp;&|nbsp;&|nbsp;&|nbsp;&|nbsp;&|nbsp; &|nbsp;&|nbsp;&|nbsp; TOTAL SALES &|nbsp; &|nbsp;&|nbsp;&|nbsp; &|nbsp;&|nbsp;&|nbsp;&|nbsp;&|nbsp; &|nbsp;&|nbsp;&|nbsp; &|nbsp;&|nbsp; &|nbsp; % &|nbsp; &|nbsp;&|nbsp;&|nbsp;&|nbsp; &|nbsp;&|nbsp;&|nbsp;&|nbsp;&|nbsp;&|nbsp; &|nbsp;&|nbsp;&|nbsp;&|nbsp;&|nbsp; &|nbsp; TOTAL &|nbsp; &|nbsp;&|nbsp; &|nbsp;&|nbsp;&|nbsp;&|nbsp; &|nbsp;&|nbsp;&|nbsp; &|nbsp;&|nbsp;&|nbsp;&|nbsp;&|nbsp; % DOL. "
"&|nbsp; &|nbsp;&|nbsp;&|nbsp; &|nbsp;&|nbsp; &|nbsp;&|nbsp;&|nbsp;&|nbsp;&|nbsp;&|nbsp;&|nbsp;&|nbsp; DELIVERED &|nbsp; &|nbsp;&|nbsp;&|nbsp; &|nbsp;&|nbsp;&|nbsp;&|nbsp;&|nbsp;&|nbsp;&|nbsp;&|nbsp; &|nbsp; DEL. &|nbsp; &|nbsp;&|nbsp;&|nbsp;&|nbsp;&|nbsp;&|nbsp;&|nbsp;&|nbsp;&|nbsp; &|nbsp;&|nbsp;&|nbsp;&|nbsp;&|nbsp;&|nbsp;&|nbsp; @ COST &|nbsp; &|nbsp;&|nbsp;&|nbsp;&|nbsp; &|nbsp;&|nbsp;&|nbsp;&|nbsp;&|nbsp;&|nbsp; &|nbsp;&|nbsp;&|nbsp;&|nbsp;&|nbsp;&|nbsp;&|nbsp;&|nbsp;&|nbsp;&|nbsp; @ SELL &|nbsp; &|nbsp;&|nbsp; &|nbsp;&|nbsp;&|nbsp;&|nbsp;&|nbsp;&|nbsp; &|nbsp;&|nbsp;&|nbsp;&|nbsp;&|nbsp;&|nbsp;&|nbsp;&|nbsp;&|nbsp; @ SELL &|nbsp; &|nbsp;&|nbsp; &|nbsp;&|nbsp;&|nbsp; &|nbsp;&|nbsp;&|nbsp;&|nbsp;&|nbsp; &|nbsp;&|nbsp;&|nbsp;&|nbsp; &|nbsp; PROFIT &|nbsp; &|nbsp;&|nbsp; &|nbsp;&|nbsp;&|nbsp;&|nbsp; &|nbsp;&|nbsp;&|nbsp;&|nbsp;&|nbsp;&|nbsp; PROFIT &|nbsp; &|nbsp;&|nbsp; &|nbsp;&|nbsp;&|nbsp;&|nbsp; &|nbsp;&|nbsp;&|nbsp; &|nbsp;&|nbsp;&|nbsp;&|nbsp;&|nbsp; PROFIT "
" &|nbsp;&|nbsp;&|nbsp;&|nbsp; &|nbsp;&|nbsp;&|nbsp; &|nbsp;&|nbsp; &|nbsp;&|nbsp;&|nbsp;&|nbsp;&|nbsp;&|nbsp;&|nbsp;&|nbsp; " "


I would like to line up some of the values in the subfooting with some of the columns but i donw know how...

ALSO I have been trying to figure out how to have a value computed totSRP(which is the subtotoal of the department for sales) divided by subtotSRP (subtotal of the comclass for sales) but what i am doing currently does not seem to be working

any help would be greatly appricated!

WebFOCUS 7.6
Windows, All Outputs

Maybe the code below will give you some inspiration.
You could add some spotmarkers

<+0>

and in your stylesheet the setting

TYPE=[type], HEADALIGN={body,internal} ,$

TABLE FILE MOVIES
PRINT
COPIES
LISTPR
WHOLESALEPR
COMPUTE AVGPR/F6.2 = LISTPR / COPIES;
COMPUTE AVG1/D12.2 = TOT.LISTPR/TOT.COPIES; NOPRINT
COMPUTE AVG2/D12.2 = TOT.WHOLESALEPR/TOT.COPIES; NOPRINT
DIRECTOR

BY RATING
BY CATEGORY
WHERE RATING IN ('G','PG13');

ON RATING RECOMPUTE
ON RATING SUBFOOT
" <+0> <+0> <+0> <+0>4th column"

ON TABLE SUMMARIZE AS 'Grand Total'
ON TABLE RECOMPUTE 
ON TABLE SUBFOOT
"Average<+0> <+0> <AVG1<AVG2  <+0> <+0>"
ON TABLE SET STYLE *
TYPE=SUBFOOT, HEADALIGN=BODY , JUSTIFY=CENTER,$

TYPE=TABFOOTING ,HEADALIGN=BODY ,JUSTIFY=RIGHT ,$
TYPE=TABFOOTING ,HEADALIGN=BODY ,OBJECT=TEXT, JUSTIFY=LEFT ,$
END

-Fred-

This code has helped me out tremendiously thank you!

how would you go about getting a percent using a subtotaled value using a larger subtotaled value

Ex.
Department 1
Comclass A
Item 123
Item 124
Item 125
Comclass A subfoot
percent of comclass A compared to Department 1
Comclass B
Item 234
Item 235
Item 236
Comclass B subfoot
percent of comclass B compared to Department 1

Department2
Comclass aa
Item 345

Maybe it can be done more simple, but this is I guess what you want.

-Fred-

-* -------------------------------------------------------------------------------------
-* Create MASTER / DATA files
-* -------------------------------------------------------------------------------------
APP FI HLDFILE DISK hldfile.mas
-RUN
-WRITE HLDFILE SEGMENT=HLDFILE, SEGTYPE=S0, $
-WRITE HLDFILE  FIELDNAME=DEP        ,E01 ,A5     ,ACTUAL=A5 ,$
-WRITE HLDFILE  FIELDNAME=COMCLASS   ,E02 ,A1     ,ACTUAL=A1 ,$
-WRITE HLDFILE  FIELDNAME=ITEM       ,E03 ,A8     ,ACTUAL=A8  ,$
-WRITE HLDFILE  FIELDNAME=QTY        ,E04 ,I8C    ,ACTUAL=A8  ,$

APP FI HLDFILE DISK hldfile.ftm
-RUN
-WRITE HLDFILE Dep1 AItem 1Aa     100
-WRITE HLDFILE Dep1 AItem 1Ab     200
-WRITE HLDFILE Dep1 AItem 1Ac     300
-WRITE HLDFILE Dep1 AItem 1Ad     400
-WRITE HLDFILE Dep1 AItem 1Ae     500
-WRITE HLDFILE Dep1 BItem 1Bf     600
-WRITE HLDFILE Dep2 BItem 2Bg     700
-WRITE HLDFILE Dep2 BItem 2Bh     800
-WRITE HLDFILE Dep2 BItem 2Bi     900
-WRITE HLDFILE Dep1 BItem 2Bj    1000
-* -------------------------------------------------------------------------------------

TABLE FILE HLDFILE
  SUM
    QTY NOPRINT
  BY DEP

  SUM
    QTY
    COMPUTE PCT1/D8.2 = (QTY/C1)      * 100; AS 'Pct within ...,DEP'
    COMPUTE PCT2/D8.2 = (QTY/TOT.QTY) * 100; AS 'Pct within ...,TOTAL ALL'
  BY DEP  COLUMN-TOTAL
  BY COMCLASS SUB-TOTAL
  ON COMCLASS SUBFOOT
  "  "
  BY ITEM
  ON TABLE SET HTMLCSS ON
  ON TABLE SET PAGE NOPAGE
  ON TABLE NOTOTAL


ON TABLE SET STYLE *
TYPE=REPORT     ,UNITS=PTS   ,FONT='VERDANA', SIZE=8        ,$
TYPE=REPORT     ,BORDER=1    ,BORDER-COLOR=RGB(210 210 210) ,$
TYPE=TITLE      ,STYLE=BOLD  ,BACKCOLOR=RGB(230 230 230)    ,$
TYPE=SUBTOTAL   ,STYLE=BOLD  ,BACKCOLOR=RGB(210 210 210)    ,$
TYPE=DATA       ,TOPGAP=2    ,BOTTOMGAP=2                   ,$
TYPE=DATA       ,BACKCOLOR=(RGB(255 255 255) RGB(245 245 245)),$
ENDSTYLE
END

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