Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Calulate Returns and Percent

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED] Calulate Returns and Percent
 Login/Join
 
Member
posted
I am new to the WEBFOCUS environment and have been trying to learn on the Job. I am trying to complete a report by calculating a total $ of returns and the return %. Then Printing the return $ and percentage on the subtotal line or below the subtotal. Here is what we have so far. I have inserted comments where I think the definitions and calculations should be. Any help would be greatly appreciated.

ENGINE INT CACHE SET ON

-*Created By Doug Moyer 2019

-*COMPONENT=Join_J001
JOIN RWPDCLDET.RWPDCLDET.CO# AND RWPDCLDET.RWPDCLDET.INV# IN INFO_ASSIST_DATA/RWPDCLDET
TO UNIQUE RWPDCLHEAD.RWPDCLHEAD.CO# AND RWPDCLHEAD.RWPDCLHEAD.INV# IN INFO_ASSIST_DATA/RWPDCLHEAD TAG J001 AS J001
END

-*COMPONENT=Define_RWPDCLDET
DEFINE FILE INFO_ASSIST_DATA/RWPDCLDET
ExtendedNet/D6.2=RWPDCLDET.RWPDCLDET.QTY * RWPDCLDET.RWPDCLDET.NET ;
ExtendedGross/D6.2=ExtendedNet - RWPDCLDET.RWPDCLDET.Extended_Cost ;
Gross/D6.2=RWPDCLDET.RWPDCLDET.NET - RWPDCLDET.RWPDCLDET.COST ;
MarkupPercent/D3.2%=ExtendedGross/RWPDCLDET.RWPDCLDET.Extended_Cost * 100 ;
GrossPercent/D3.2%=ExtendedGross/ExtendedNet * 100 ;

-* Define Return $
-* Define Return %

END

-DEFAULTH &WF_SUMMARY='Summary';
-DEFAULTH &WF_TITLE='WebFOCUS Report';
TABLE FILE INFO_ASSIST_DATA/RWPDCLDET
SUM
ExtendedNet
RWPDCLDET.RWPDCLDET.Extended_Cost
ExtendedGross

-* SUM Return $ IF RWPDCLDET.RWPDCLDET.TRANSD EQ 'CounterReturn'
-* AND COMPUTE Return %

AND COMPUTE MarkupPercent/D3.2%=ExtendedGross/RWPDCLDET.RWPDCLDET.Extended_Cost * 100 ;
AND COMPUTE GrossPercent/D3.2%=ExtendedGross/ExtendedNet * 100 ;

BY J001.RWPDCLHEAD.CUSTKEY NOPRINT PAGE-BREAK RECOMPUTE SUM. ExtendedNet SUM. RWPDCLDET.RWPDCLDET.Extended_Cost SUM. ExtendedGross SUM. MarkupPercent SUM. GrossPercent AS 'Subtotal: '

-* Print Return $ and Return % on Subtotal line

BY J001.RWPDCLHEAD.FULLNAME
BY RWPDCLDET.RWPDCLDET.INV#
BY J001.RWPDCLHEAD.CPID
BY RWPDCLDET.RWPDCLDET.DATE
BY RWPDCLDET.RWPDCLDET.CLOSEDATE
BY RWPDCLDET.RWPDCLDET.LINE
BY RWPDCLDET.RWPDCLDET.TCODE NOPRINT
BY RWPDCLDET.RWPDCLDET.TRANSD
BY RWPDCLDET.RWPDCLDET.SCODE NOPRINT
BY RWPDCLDET.RWPDCLDET.PART
BY RWPDCLDET.RWPDCLDET.QTY
BY RWPDCLDET.RWPDCLDET.LIST
BY RWPDCLDET.RWPDCLDET.NET
BY RWPDCLDET.RWPDCLDET.COST
BY Gross
BY RWPDCLDET.RWPDCLDET.PRCOVR

WHERE RWPDCLDET.RWPDCLDET.CO# EQ &CO#.(OR(,,,,,, |FORMAT=A3)).Company:.;
WHERE RWPDCLDET.RWPDCLDET.CLOSEDATE GE &StartDate.(|FORMAT=YYMD).Enter start date .QUOTEDSTRING;
WHERE RWPDCLDET.RWPDCLDET.CLOSEDATE LE &Enddate.(|FORMAT=YYMD).Enter end date .QUOTEDSTRING;
WHERE RWPDCLDET.RWPDCLDET.LINE NE 950 OR 996 OR 998 OR 999;
WHERE RWPDCLDET.RWPDCLDET.SCODE NE 'H' OR 'S';
WHERE RWPDCLDET.RWPDCLDET.TCODE NE 'LS';
WHERE RWPDCLDET.RWPDCLDET.PART OMITS '-C';

ON TABLE SUBHEAD
"Parts Counter Sales Report"
ON TABLE PCHOLD FORMAT XLSX
ON TABLE NOTOTAL
ON TABLE SET CACHELINES 100
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET SQUEEZE ON
ON TABLE SET HTMLCSS ON
ON TABLE SET HTMLENCODE ON
ON TABLE SET EMPTYREPORT ON
ON TABLE SET GRWIDTH 1
ON TABLE SET STYLE *

INCLUDE=IBFS:/FILE/IBI_HTML_DIR/javaassist/intl/EN/ENIADefault_combine.sty,$
TYPE=REPORT, TITLETEXT=&WF_TITLE.QUOTEDSTRING, SUMMARY=&WF_SUMMARY.QUOTEDSTRING, HFREEZE=OFF, $
TYPE=TABHEADING, LINE=1, JUSTIFY=CENTER, $
TYPE=TABHEADING, LINE=1, ITEM=1, OBJECT=TEXT, SIZE=14, STYLE=BOLD+ITALIC, $
TYPE=SUBFOOT, BY=J001.RWPDCLHEAD.CUSTKEY, LINE=1, JUSTIFY=LEFT, $
TYPE=SUBFOOT, BY=J001.RWPDCLHEAD.CUSTKEY, LINE=1, ITEM=1, OBJECT=TEXT, SIZE=10, STYLE=BOLD, $
ENDSTYLE
END

-RUN

This message has been edited. Last edited by: FP Mod Chuck,
 
Posts: 4 | Registered: May 21, 2019Report This Post
Virtuoso
posted Hide Post
Hi,

Welcome in WF world. You will find that there is, most of the time, more than one way to produce the same result.

First, you must not DEFINE MarkupPercent & GrossPercent since you want them to be RECOMPUTE in a subtotal. Keep only those that you have COMPUTEd. This will make your code clearer and lighter.
Also, normally, you don't want to SUM a percentage except if all the distinct one should totalize 100%. Otherwise you need the recompute it and WF will do it automatically while it defined as a COMPUTE field.
A numeric DEFINEd field (such as a DB field) will be summarized in a subtotal or total and a COMPUTEd one will be recalculated as per COMPUTE definition. Reason why you normally COMPUTE a percentage and not DEFINE it.

Second, below a simple sample where I have subtotal by COUNTRY where only some fields are included and a report total where all fields are included.
TABLE FILE CAR
SUM SEATS
    DEALER_COST
    RETAIL_COST
    COMPUTE RATE /P6.2 = DEALER_COST / RETAIL_COST * 100;
BY COUNTRY NOPRINT
ON COUNTRY RECOMPUTE DEALER_COST RATE AS 'Subtotal'
BY CAR
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE COLUMN-TOTAL AS 'Grand Total'
END
-RUN

As for this
quote:

-* SUM Return $ IF RWPDCLDET.RWPDCLDET.TRANSD EQ 'CounterReturn'
-* AND COMPUTE Return %

Try the following
ON RWPDCLDET.RWPDCLDET.TRANSD RECOMPUTE AS 'Subtotal: '
WHEN RWPDCLDET.RWPDCLDET.TRANSD EQ 'CounterReturn'

Sample:
TABLE FILE CAR
SUM SEATS
    DEALER_COST
    RETAIL_COST
    COMPUTE RATE /P6.2 = DEALER_COST / RETAIL_COST * 100;
BY COUNTRY NOPRINT
ON COUNTRY RECOMPUTE DEALER_COST RATE AS 'Subtotal'
BY CAR
ON CAR     RECOMPUTE AS 'Sub-Total'
WHEN CAR EQ 'ALFA ROMEO' OR 'JAGUAR'
BY MODEL
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE COLUMN-TOTAL AS 'Grand Total'
END
-RUN


Hope this help

Please use the code tag when posting sample code, layout or result. It's the last icon on the ribbon
</>


WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
 
Posts: 2409 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013Report This Post
Member
posted Hide Post
I have still had no luck. I changed the program as suggested. Here is what I have right now and it is working correctly. I have enclosed a sample output so you can see visually what I would like to accomplish. The names have been changed to protect the innocent. In the sample output you will see a column description that represents the type of transaction. They show either 'Counter Sale' or Counter Return'. I need to be able to Sum all the returns(ExtendedNet) for the individual Accounts and calculate a return percentage (sum of returns/ sum of ExtendedNet). I guess I do not fully understand the language. I have tried many combinations with no resolve. The output is not formatted here but is correct in an EXCEL spreadsheet.

ENGINE INT CACHE SET ON

-*COMPONENT=Join_J001
JOIN RWPDCLDET.RWPDCLDET.CO# AND RWPDCLDET.RWPDCLDET.INV# IN INFO_ASSIST_DATA/RWPDCLDET
TO UNIQUE RWPDCLHEAD.RWPDCLHEAD.CO# AND RWPDCLHEAD.RWPDCLHEAD.INV# IN INFO_ASSIST_DATA/RWPDCLHEAD TAG J001 AS J001
END

-*COMPONENT=Define_RWPDCLDET
DEFINE FILE INFO_ASSIST_DATA/RWPDCLDET
 ExtendedNet/D6.2=RWPDCLDET.RWPDCLDET.QTY * RWPDCLDET.RWPDCLDET.NET ;
 ExtendedGross/D6.2=ExtendedNet - RWPDCLDET.RWPDCLDET.Extended_Cost ;
 Gross/D6.2=RWPDCLDET.RWPDCLDET.NET - RWPDCLDET.RWPDCLDET.COST ;
 MarkupPercent/D3.2%=ExtendedGross/RWPDCLDET.RWPDCLDET.Extended_Cost * 100 ;
 GrossPercent/D3.2%=ExtendedGross/ExtendedNet * 100 ;
END

-DEFAULTH &WF_SUMMARY='Summary';
-DEFAULTH &WF_TITLE='WebFOCUS Report';
TABLE FILE INFO_ASSIST_DATA/RWPDCLDET

SUM
ExtendedNet
RWPDCLDET.RWPDCLDET.Extended_Cost
ExtendedGross
AND COMPUTE MarkupPercent/D3.2%=ExtendedGross/RWPDCLDET.RWPDCLDET.Extended_Cost * 100 ;
AND COMPUTE GrossPercent/D3.2%=ExtendedGross/ExtendedNet * 100 ;

BY J001.RWPDCLHEAD.CUSTKEY NOPRINT PAGE-BREAK
BY J001.RWPDCLHEAD.FULLNAME
BY RWPDCLDET.RWPDCLDET.INV#
BY J001.RWPDCLHEAD.CPID
BY RWPDCLDET.RWPDCLDET.DATE
BY RWPDCLDET.RWPDCLDET.CLOSEDATE
BY RWPDCLDET.RWPDCLDET.LINE
BY RWPDCLDET.RWPDCLDET.TCODE NOPRINT
BY RWPDCLDET.RWPDCLDET.TRANSD
BY RWPDCLDET.RWPDCLDET.SCODE NOPRINT
BY RWPDCLDET.RWPDCLDET.PART
BY RWPDCLDET.RWPDCLDET.QTY
BY RWPDCLDET.RWPDCLDET.LIST
BY RWPDCLDET.RWPDCLDET.NET
BY RWPDCLDET.RWPDCLDET.COST
BY Gross
BY RWPDCLDET.RWPDCLDET.PRCOVR
BY ExtendedNet NOPRINT
BY RWPDCLDET.RWPDCLDET.Extended_Cost NOPRINT
BY ExtendedGross NOPRINT
BY MarkupPercent NOPRINT
BY GrossPercent NOPRINT

ON  J001.RWPDCLHEAD.CUSTKEY SUMMARIZE
        

WHERE RWPDCLDET.RWPDCLDET.CO# EQ &CO#.(OR(<BO1>,<BO2>,<BO3>,<BO4>,<BO5>,<BO7>,<BO8> |FORMAT=A3)).Company:.;
WHERE RWPDCLDET.RWPDCLDET.CLOSEDATE GE &StartDate.(|FORMAT=YYMD).Enter start date .QUOTEDSTRING;
WHERE RWPDCLDET.RWPDCLDET.CLOSEDATE LE &Enddate.(|FORMAT=YYMD).Enter end date .QUOTEDSTRING;
WHERE RWPDCLDET.RWPDCLDET.LINE NE 950 OR 996 OR 998 OR 999;
WHERE RWPDCLDET.RWPDCLDET.SCODE NE 'H' OR 'S';
WHERE RWPDCLDET.RWPDCLDET.TCODE NE 'LS';
WHERE RWPDCLDET.RWPDCLDET.PART OMITS '-C';

ON TABLE SUBHEAD
"Parts Counter Sales Report"
ON TABLE PCHOLD FORMAT XLSX
ON TABLE NOTOTAL
ON TABLE SET CACHELINES 100
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET SQUEEZE ON
ON TABLE SET HTMLCSS ON
ON TABLE SET HTMLENCODE ON
ON TABLE SET EMPTYREPORT ON
ON TABLE SET GRWIDTH 1
ON TABLE SET STYLE *


INCLUDE=IBFS:/FILE/IBI_HTML_DIR/javaassist/intl/EN/ENIADefault_combine.sty,$
TYPE=REPORT, TITLETEXT=&WF_TITLE.QUOTEDSTRING, SUMMARY=&WF_SUMMARY.QUOTEDSTRING, HFREEZE=OFF, $
TYPE=TABHEADING, LINE=1, JUSTIFY=CENTER, $
TYPE=TABHEADING, LINE=1, ITEM=1, OBJECT=TEXT, SIZE=14, STYLE=BOLD+ITALIC, $
TYPE=SUBFOOT, BY=J001.RWPDCLHEAD.CUSTKEY, LINE=1, JUSTIFY=LEFT, $
TYPE=SUBFOOT, BY=J001.RWPDCLHEAD.CUSTKEY, LINE=1, ITEM=1, OBJECT=TEXT, SIZE=10, STYLE=BOLD, $
ENDSTYLE
END

-RUN


Parts Counter Sales Report																		
																		
Customer Name	Invoice/RO	Counterperson ID	Date	Close Date	Line#	Trans Code Description	Part Number	Quantity	List Price	Net	Cost	Gross	Price Override	ExtendedNet	Extended Cost	ExtendedGross	MarkupPercent	GrossPercent
WHOLESALE ACCOUNT 1069605	5014776	DON	2019/05/03	2019/05/03	0	Counter Sale	23299758	1	40.08	30.00	24.00	6.00	N	30.00	24.00	6.00	25.00%	20.00%
WHOLESALE ACCOUNT 1069605	5014776	DON	2019/05/03	2019/05/03	0	Counter Sale	84150736	1	460.92	345.00	276.00	69.00	N	345.00	276.00	69.00	25.00%	20.00%
WHOLESALE ACCOUNT 1069605	5014776	DON	2019/05/03	2019/05/03	0	Counter Sale	84172707	1	380.70	284.96	227.97	56.99	N	284.96	227.97	56.99	25.00%	20.00%
WHOLESALE ACCOUNT 1069605	5014776	DON	2019/05/03	2019/05/03	0	Counter Sale	84226246	1	160.32	120.00	96.00	24.00	N	120.00	96.00	24.00	25.00%	20.00%
WHOLESALE ACCOUNT 1069605	5014776	DON	2019/05/03	2019/05/03	0	Counter Sale	84293394	1	8.76	6.56	5.25	1.31	N	6.56	5.25	1.31	24.95%	19.97%
WHOLESALE ACCOUNT 1069605	5014776	DON	2019/05/03	2019/05/03	0	Counter Sale	84385251	1	460.92	345.00	276.00	69.00	N	345.00	276.00	69.00	25.00%	20.00%
WHOLESALE ACCOUNT 1069605	5014776	DON	2019/05/03	2019/05/03	0	Counter Sale	84431746	1	25.66	19.21	15.37	3.84	N	19.21	15.37	3.84	24.98%	19.99%
WHOLESALE ACCOUNT 1069605	5014995	DON	2019/05/07	2019/05/07	0	Counter Sale	84569928	1	325.00	224.25	195.00	29.25	N	224.25	195.00	29.25	15.00%	13.04%
WHOLESALE ACCOUNT 1069605	5015109	JAC	2019/05/09	2019/05/09	0	Counter Sale	15129644	1	60.12	45.00	36.00	9.00	N	45.00	36.00	9.00	25.00%	20.00%
WHOLESALE ACCOUNT 1069605	5015109	JAC	2019/05/09	2019/05/09	0	Counter Sale	22775442	1	78.05	58.42	46.74	11.68	N	58.42	46.74	11.68	24.99%	19.99%
WHOLESALE ACCOUNT 1069605	5015109	JAC	2019/05/09	2019/05/09	0	Counter Sale	22775449	1	75.15	56.25	45.00	11.25	N	56.25	45.00	11.25	25.00%	20.00%
WHOLESALE ACCOUNT 1069605	5015109	JAC	2019/05/09	2019/05/09	0	Counter Sale	22894860	1	55.00	46.75	41.25	5.50	N	46.75	41.25	5.50	13.33%	11.76%
WHOLESALE ACCOUNT 1069605	5015109	JAC	2019/05/09	2019/05/09	0	Counter Sale	84208315	1	834.96	624.97	499.98	124.99	N	624.97	499.98	124.99	25.00%	20.00%
WHOLESALE ACCOUNT 1069605	5015531	JAC	2019/05/16	2019/05/16	0	Counter Sale	15244377	1	1056.67	738.22	632.74	105.48	N	738.22	632.74	105.48	16.67%	14.29%
WHOLESALE ACCOUNT 1069605	5015743	DPR	2019/05/20	2019/05/20	0	Counter Return	22865364	-1	38.39	28.73	22.99	5.74	Y	-28.73	-22.99	-5.74	24.97%	19.98%
WHOLESALE ACCOUNT 1069605	5015756	DON	2019/05/21	2019/05/21	0	Counter Sale	15200596	1	133.36	93.17	79.86	13.31	N	93.17	79.86	13.31	16.67%	14.29%
WHOLESALE ACCOUNT 1069605	5015756	DON	2019/05/21	2019/05/21	0	Counter Sale	15779675	1	33.75	23.58	20.21	3.37	N	23.58	20.21	3.37	16.67%	14.29%
*TOTAL CUSTKEY    1069605														3,032.61	2,494.38	538.23	21.58%	17.75%
																		
Customer Name	Invoice/RO	Counterperson ID	Date	Close Date	Line#	Trans Code Description	Part Number	Quantity	List Price	Net	Cost	Gross	Price Override	ExtendedNet	Extended Cost	ExtendedGross	MarkupPercent	GrossPercent
WHOLESALE ACCOUNT 1071925	5015195	DON	2019/05/10	2019/05/10	0	Counter Sale	12602848	1	31.48	23.60	17.94	5.66	N	23.60	17.94	5.66	31.55%	23.98%
WHOLESALE ACCOUNT 1071925	5015195	DON	2019/05/10	2019/05/10	0	Counter Sale	12607947	1	15.31	10.72	7.65	3.07	N	10.72	7.65	3.07	40.13%	28.64%
WHOLESALE ACCOUNT 1071925	5015246	DON	2019/05/10	2019/05/10	0	Counter Sale	14090906	1	29.86	20.90	14.93	5.97	N	20.90	14.93	5.97	39.99%	28.56%
WHOLESALE ACCOUNT 1071925	5015928	JAC	2019/05/23	2019/05/23	0	Counter Sale	12586959	1	16.66	12.34	9.49	2.85	N	12.34	9.49	2.85	30.03%	23.10%
WHOLESALE ACCOUNT 1071925	5015928	JAC	2019/05/23	2019/05/23	0	Counter Sale	12597417	1	22.71	16.84	12.95	3.89	N	16.84	12.95	3.89	30.04%	23.10%
WHOLESALE ACCOUNT 1071925	5015928	JAC	2019/05/23	2019/05/23	0	Counter Sale	12600461	1	23.83	17.65	13.58	4.07	N	17.65	13.58	4.07	29.97%	23.06%
WHOLESALE ACCOUNT 1071925	5015928	JAC	2019/05/23	2019/05/23	0	Counter Sale	12600462	1	23.83	17.65	13.58	4.07	N	17.65	13.58	4.07	29.97%	23.06%
WHOLESALE ACCOUNT 1071925	5015928	JAC	2019/05/23	2019/05/23	0	Counter Sale	12623513	1	23.58	17.47	13.44	4.03	N	17.47	13.44	4.03	29.99%	23.07%
WHOLESALE ACCOUNT 1071925	5015928	JAC	2019/05/23	2019/05/23	0	Counter Sale	12623514	1	22.80	16.90	13.00	3.90	N	16.90	13.00	3.90	30.00%	23.08%
WHOLESALE ACCOUNT 1071925	5015989	DPR	2019/05/23	2019/05/23	0	Counter Sale	12566429	1	5.81	3.55	2.91	.64	Y	3.55	2.91	.64	21.99%	18.03%
WHOLESALE ACCOUNT 1071925	5015989	DPR	2019/05/23	2019/05/23	0	Counter Sale	12584040	1	5.83	3.56	2.92	.64	Y	3.56	2.92	.64	21.92%	17.98%
*TOTAL CUSTKEY    1071925														161.18	122.39	38.79	31.69%	24.07%
																		
																		
Customer Name	Invoice/RO	Counterperson ID	Date	Close Date	Line#	Trans Code Description	Part Number	Quantity	List Price	Net	Cost	Gross	Price Override	ExtendedNet	Extended Cost	ExtendedGross	MarkupPercent	GrossPercent
WHOLESALE ACCOUNT 1072030	5015162	DON	2019/05/09	2019/05/09	0	Counter Sale	12623519	1	9.95	7.46	5.97	1.49	N	7.46	5.97	1.49	24.96%	19.97%
WHOLESALE ACCOUNT 1072030	5015390	JAC	2019/05/14	2019/05/14	0	Counter Sale	12601677	1	158.64	118.98	90.43	28.55	N	118.98	90.43	28.55	31.57%	24.00%
WHOLESALE ACCOUNT 1072030	5015390	JAC	2019/05/14	2019/05/14	0	Counter Sale	12638428	1	4.36	3.27	2.48	.79	N	3.27	2.48	.79	31.85%	24.16%
WHOLESALE ACCOUNT 1072030	5015390	JAC	2019/05/14	2019/05/14	0	Counter Sale	12638606	1	4.39	2.73	2.20	.53	Y	2.73	2.20	.53	24.09%	19.41%
*TOTAL CUSTKEY    1072030														132.44	101.08	31.36	31.02%	23.68%
																		
																		
Customer Name	Invoice/RO	Counterperson ID	Date	Close Date	Line#	Trans Code Description	Part Number	Quantity	List Price	Net	Cost	Gross	Price Override	ExtendedNet	Extended Cost	ExtendedGross	MarkupPercent	GrossPercent
WHOLESALE ACCOUNT 1072581	5014674	DON	2019/05/06	2019/05/06	0	Counter Sale	22960927	1	115.21	46.23	68.99	-22.76	Y	46.23	68.99	-22.76	-32.99%	-49.23%
WHOLESALE ACCOUNT 1072581	5014674	DON	2019/05/06	2019/05/06	0	Counter Sale	23326086	1	731.64	422.10	438.11	-16.01	Y	422.10	438.11	-16.01	-3.65%	-3.79%
WHOLESALE ACCOUNT 1072581	5014685	DON	2019/05/06	2019/05/06	0	Counter Sale	20983814	1	88.17	48.91	52.80	-3.89	Y	48.91	52.80	-3.89	-7.37%	-7.95%
WHOLESALE ACCOUNT 1072581	5014685	DON	2019/05/06	2019/05/06	0	Counter Sale	22816699	1	90.41	62.95	54.14	8.81	N	62.95	54.14	8.81	16.27%	14.00%
WHOLESALE ACCOUNT 1072581	5014685	DON	2019/05/06	2019/05/06	0	Counter Sale	23400078	1	178.72	118.45	101.87	16.58	N	118.45	101.87	16.58	16.28%	14.00%
WHOLESALE ACCOUNT 1072581	5014685	DON	2019/05/06	2019/05/06	0	Counter Sale	23468362	1	305.27	176.21	182.80	-6.59	Y	176.21	182.80	-6.59	-3.61%	-3.74%
WHOLESALE ACCOUNT 1072581	5014685	DON	2019/05/06	2019/05/06	0	Counter Sale	25830934	1	68.97	48.02	41.30	6.72	N	48.02	41.30	6.72	16.27%	13.99%
WHOLESALE ACCOUNT 1072581	5014761	DON	2019/05/03	2019/05/03	0	Counter Sale	22900139	1	587.67	409.19	351.90	57.29	N	409.19	351.90	57.29	16.28%	14.00%
WHOLESALE ACCOUNT 1072581	5014761	DON	2019/05/03	2019/05/03	0	Counter Sale	23134116	1	49.58	34.52	29.69	4.83	N	34.52	29.69	4.83	16.27%	13.99%
WHOLESALE ACCOUNT 1072581	5014761	DON	2019/05/03	2019/05/03	0	Counter Sale	23349768	1	42.72	28.31	24.35	3.96	N	28.31	24.35	3.96	16.26%	13.99%
WHOLESALE ACCOUNT 1072581	5014761	DON	2019/05/03	2019/05/03	0	Counter Sale	23428268	1	207.39	144.41	124.19	20.22	N	144.41	124.19	20.22	16.28%	14.00%
WHOLESALE ACCOUNT 1072581	5014761	DON	2019/05/03	2019/05/03	0	Counter Sale	23491505	1	162.48	107.70	92.62	15.08	N	107.70	92.62	15.08	16.28%	14.00%
WHOLESALE ACCOUNT 1072581	5014774	DON	2019/05/03	2019/05/03	0	Counter Sale	84515909	1	330.76	230.30	227.77	2.53	Y	230.30	227.77	2.53	1.11%	1.10%
WHOLESALE ACCOUNT 1072581	5014777	DON	2019/05/06	2019/05/06	0	Counter Sale	20993964	1	834.96	581.38	499.98	81.40	N	581.38	499.98	81.40	16.28%	14.00%
WHOLESALE ACCOUNT 1072581	5014777	DON	2019/05/06	2019/05/06	0	Counter Sale	23269921	2	75.09	52.29	44.97	7.32	N	104.58	89.94	14.64	16.28%	14.00%
WHOLESALE ACCOUNT 1072581	5014777	DON	2019/05/06	2019/05/06	0	Counter Sale	84077959	1	1352.64	941.83	809.97	131.86	N	941.83	809.97	131.86	16.28%	14.00%
WHOLESALE ACCOUNT 1072581	5014839	JAC	2019/05/06	2019/05/06	0	Counter Sale	23224609	1	210.26	146.41	125.91	20.50	N	146.41	125.91	20.50	16.28%	14.00%
WHOLESALE ACCOUNT 1072581	5014843	JAC	2019/05/06	2019/05/06	0	Counter Sale	84112235	1	345.09	228.72	196.70	32.02	N	228.72	196.70	32.02	16.28%	14.00%
WHOLESALE ACCOUNT 1072581	5014844	DON	2019/05/06	2019/05/06	0	Counter Sale	22960925	1	50.53	35.19	30.26	4.93	N	35.19	30.26	4.93	16.29%	14.01%
WHOLESALE ACCOUNT 1072581	5014929	DON	2019/05/07	2019/05/07	0	Counter Sale	23282892	1	518.56	361.07	310.52	50.55	N	361.07	310.52	50.55	16.28%	14.00%
WHOLESALE ACCOUNT 1072581	5014930	DON	2019/05/07	2019/05/07	0	Counter Sale	23231889	1	30.47	21.22	18.25	2.97	N	21.22	18.25	2.97	16.27%	14.00%
WHOLESALE ACCOUNT 1072581	5015211	DON	2019/05/10	2019/05/10	0	Counter Sale	11609952	2	5.24	3.48	2.99	.49	N	6.96	5.98	.98	16.39%	14.08%
WHOLESALE ACCOUNT 1072581	5015211	DON	2019/05/10	2019/05/10	0	Counter Sale	11609952	2	5.24	3.48	2.99	.49	N	6.96	5.98	.98	16.39%	14.08%
WHOLESALE ACCOUNT 1072581	5015483	DON	2019/05/15	2019/05/15	0	Counter Return	23108150	-1	40.08	27.60	24.00	3.60	Y	-27.60	-24.00	-3.60	15.00%	13.04%
WHOLESALE ACCOUNT 1072581	5015657	DON	2019/05/20	2019/05/20	0	Counter Sale	95256263	1	19.30	13.44	11.56	1.88	N	13.44	11.56	1.88	16.26%	13.99%
WHOLESALE ACCOUNT 1072581	5015657	DON	2019/05/20	2019/05/20	0	Counter Sale	95291864	1	157.48	109.65	94.30	15.35	N	109.65	94.30	15.35	16.28%	14.00%
*TOTAL CUSTKEY    1072581														4,407.11	3,965.88	441.23	11.13%	10.01%
																		
Customer Name	Invoice/RO	Counterperson ID	Date	Close Date	Line#	Trans Code Description	Part Number	Quantity	List Price	Net	Cost	Gross	Price Override	ExtendedNet	Extended Cost	ExtendedGross	MarkupPercent	GrossPercent
WHOLSALE ACCOUNT 1078481	5014876	DON	2019/05/06	2019/05/06	0	Counter Sale	9599488	1	15.00	12.94	11.25	1.69	N	12.94	11.25	1.69	15.02%	13.06%
WHOLSALE ACCOUNT 1078481	5014883	DON	2019/05/06	2019/05/06	0	Counter Sale	9596070	1	9.00	6.20	5.39	.81	N	6.20	5.39	.81	15.03%	13.06%
WHOLSALE ACCOUNT 1078481	5014884	DON	2019/05/06	2019/05/06	0	Counter Return	9599488	-1	15.00	12.94	11.25	1.69	Y	-12.94	-11.25	-1.69	15.02%	13.06%
WHOLSALE ACCOUNT 1078481	5015025	DON	2019/05/08	2019/05/08	0	Counter Sale	25962840	1	157.89	108.73	94.55	14.18	N	108.73	94.55	14.18	15.00%	13.04%
WHOLSALE ACCOUNT 1078481	5015189	DON	2019/05/09	2019/05/09	0	Counter Sale	19352194	6	2.98	2.06	1.79	.27	N	12.36	10.74	1.62	15.08%	13.11%
WHOLSALE ACCOUNT 1078481	5015189	DON	2019/05/09	2019/05/09	0	Counter Sale	84142841	1	20.55	14.16	12.31	1.85	N	14.16	12.31	1.85	15.03%	13.07%
WHOLSALE ACCOUNT 1078481	5015279	DON	2019/05/13	2019/05/13	0	Counter Sale	13597530	1	78.90	54.34	47.25	7.09	N	54.34	47.25	7.09	15.01%	13.05%
WHOLSALE ACCOUNT 1078481	5015279	DON	2019/05/13	2019/05/13	0	Counter Sale	15129652	1	65.07	44.82	38.97	5.85	N	44.82	38.97	5.85	15.01%	13.05%
WHOLSALE ACCOUNT 1078481	5015279	DON	2019/05/13	2019/05/13	0	Counter Sale	22987368	1	180.30	124.17	107.97	16.20	N	124.17	107.97	16.20	15.00%	13.05%
WHOLSALE ACCOUNT 1078481	5015279	DON	2019/05/13	2019/05/13	0	Counter Sale	23269921	1	75.09	51.72	44.97	6.75	N	51.72	44.97	6.75	15.01%	13.05%
WHOLSALE ACCOUNT 1078481	5015279	DON	2019/05/13	2019/05/13	0	Counter Sale	23291512	1	72.07	49.63	43.16	6.47	N	49.63	43.16	6.47	14.99%	13.04%
WHOLSALE ACCOUNT 1078481	5015287	DON	2019/05/13	2019/05/13	0	Counter Sale	95092195	1	222.91	113.23	133.48	-20.25	Y	113.23	133.48	-20.25	-15.17%	-17.88%
WHOLSALE ACCOUNT 1078481	5015287	DON	2019/05/13	2019/05/13	0	Counter Sale	95217520	1	341.28	235.01	204.36	30.65	N	235.01	204.36	30.65	15.00%	13.04%
WHOLSALE ACCOUNT 1078481	5015423	DON	2019/05/14	2019/05/14	0	Counter Sale	13588034	1	39.16	26.97	23.45	3.52	N	26.97	23.45	3.52	15.01%	13.05%
WHOLSALE ACCOUNT 1078481	5015423	DON	2019/05/14	2019/05/14	0	Counter Sale	19352194	12	2.98	2.06	1.79	.27	N	24.72	21.48	3.24	15.08%	13.11%
WHOLSALE ACCOUNT 1078481	5015423	DON	2019/05/14	2019/05/14	0	Counter Sale	19354103	1	436.50	300.59	261.38	39.21	N	300.59	261.38	39.21	15.00%	13.04%
WHOLSALE ACCOUNT 1078481	5015423	DON	2019/05/14	2019/05/14	0	Counter Sale	23368270	1	30.06	20.70	18.00	2.70	N	20.70	18.00	2.70	15.00%	13.04%
WHOLSALE ACCOUNT 1078481	5015423	DON	2019/05/14	2019/05/14	0	Counter Sale	23368275	1	42.96	29.59	25.73	3.86	N	29.59	25.73	3.86	15.00%	13.04%
WHOLSALE ACCOUNT 1078481	5015423	DON	2019/05/14	2019/05/14	0	Counter Sale	23401134	1	42.96	29.59	25.73	3.86	N	29.59	25.73	3.86	15.00%	13.04%
WHOLSALE ACCOUNT 1078481	5015423	DON	2019/05/14	2019/05/14	0	Counter Sale	84142839	1	20.55	14.16	12.31	1.85	N	14.16	12.31	1.85	15.03%	13.07%
WHOLSALE ACCOUNT 1078481	5015423	DON	2019/05/14	2019/05/14	0	Counter Sale	84171963	1	996.99	686.55	597.00	89.55	N	686.55	597.00	89.55	15.00%	13.04%
WHOLSALE ACCOUNT 1078481	5015427	DON	2019/05/14	2019/05/14	0	Counter Return	13588034	-1	39.16	26.97	23.45	3.52	Y	-26.97	-23.45	-3.52	15.01%	13.05%
WHOLSALE ACCOUNT 1078481	5015427	DON	2019/05/14	2019/05/14	0	Counter Return	19352194	-12	2.98	2.06	1.79	.27	Y	-24.72	-21.48	-3.24	15.08%	13.11%
WHOLSALE ACCOUNT 1078481	5015427	DON	2019/05/14	2019/05/14	0	Counter Return	19354103	-1	436.50	300.59	261.38	39.21	Y	-300.59	-261.38	-39.21	15.00%	13.04%
WHOLSALE ACCOUNT 1078481	5015427	DON	2019/05/14	2019/05/14	0	Counter Return	23368270	-1	30.06	20.70	18.00	2.70	Y	-20.70	-18.00	-2.70	15.00%	13.04%
WHOLSALE ACCOUNT 1078481	5015427	DON	2019/05/14	2019/05/14	0	Counter Return	23368275	-1	42.96	29.59	25.73	3.86	Y	-29.59	-25.73	-3.86	15.00%	13.04%
WHOLSALE ACCOUNT 1078481	5015427	DON	2019/05/14	2019/05/14	0	Counter Return	23401134	-1	42.96	29.59	25.73	3.86	Y	-29.59	-25.73	-3.86	15.00%	13.04%
WHOLSALE ACCOUNT 1078481	5015427	DON	2019/05/14	2019/05/14	0	Counter Return	84142839	-1	20.55	14.16	12.31	1.85	Y	-14.16	-12.31	-1.85	15.03%	13.07%
WHOLSALE ACCOUNT 1078481	5015427	DON	2019/05/14	2019/05/14	0	Counter Return	84171963	-1	996.99	686.55	597.00	89.55	Y	-686.55	-597.00	-89.55	15.00%	13.04%
WHOLSALE ACCOUNT 1078481	5015428	DON	2019/05/14	2019/05/14	0	Counter Sale	13588034	1	39.16	26.97	23.45	3.52	N	26.97	23.45	3.52	15.01%	13.05%
WHOLSALE ACCOUNT 1078481	5015428	DON	2019/05/14	2019/05/14	0	Counter Sale	19352194	12	2.98	2.06	1.79	.27	N	24.72	21.48	3.24	15.08%	13.11%
WHOLSALE ACCOUNT 1078481	5015428	DON	2019/05/14	2019/05/14	0	Counter Sale	19354103	1	436.50	256.61	261.38	-4.77	Y	256.61	261.38	-4.77	-1.82%	-1.86%
WHOLSALE ACCOUNT 1078481	5015428	DON	2019/05/14	2019/05/14	0	Counter Sale	23368270	1	30.06	20.70	18.00	2.70	N	20.70	18.00	2.70	15.00%	13.04%
WHOLSALE ACCOUNT 1078481	5015428	DON	2019/05/14	2019/05/14	0	Counter Sale	23368275	1	42.96	29.59	25.73	3.86	N	29.59	25.73	3.86	15.00%	13.04%
WHOLSALE ACCOUNT 1078481	5015428	DON	2019/05/14	2019/05/14	0	Counter Sale	23401134	1	42.96	29.59	25.73	3.86	N	29.59	25.73	3.86	15.00%	13.04%
WHOLSALE ACCOUNT 1078481	5015428	DON	2019/05/14	2019/05/14	0	Counter Sale	84142839	1	20.55	14.16	12.31	1.85	N	14.16	12.31	1.85	15.03%	13.07%
WHOLSALE ACCOUNT 1078481	5015428	DON	2019/05/14	2019/05/14	0	Counter Sale	84171963	1	996.99	686.55	597.00	89.55	N	686.55	597.00	89.55	15.00%	13.04%
WHOLSALE ACCOUNT 1078481	5015436	DON	2019/05/15	2019/05/15	0	Counter Sale	22763887	1	140.33	96.63	84.03	12.60	N	96.63	84.03	12.60	14.99%	13.04%
WHOLSALE ACCOUNT 1078481	5015450	DON	2019/05/15	2019/05/15	0	Counter Sale	15040331	1	11.33	7.81	6.79	1.02	N	7.81	6.79	1.02	15.02%	13.06%
WHOLSALE ACCOUNT 1078481	5015450	DON	2019/05/15	2019/05/15	0	Counter Sale	15769308	1	23.19	15.97	13.89	2.08	N	15.97	13.89	2.08	14.97%	13.02%
WHOLSALE ACCOUNT 1078481	5015450	DON	2019/05/15	2019/05/15	0	Counter Sale	22903540	1	42.51	29.28	25.46	3.82	N	29.28	25.46	3.82	15.00%	13.05%
WHOLSALE ACCOUNT 1078481	5015454	DON	2019/05/15	2019/05/15	0	Counter Sale	15040331	1	11.33	7.81	6.79	1.02	N	7.81	6.79	1.02	15.02%	13.06%
WHOLSALE ACCOUNT 1078481	5015454	DON	2019/05/15	2019/05/15	0	Counter Sale	15769308	1	23.19	15.97	13.89	2.08	N	15.97	13.89	2.08	14.97%	13.02%
WHOLSALE ACCOUNT 1078481	5015454	DON	2019/05/15	2019/05/15	0	Counter Sale	22890963	1	43.55	29.99	26.08	3.91	N	29.99	26.08	3.91	14.99%	13.04%
WHOLSALE ACCOUNT 1078481	5015454	DON	2019/05/15	2019/05/15	0	Counter Sale	22890966	1	38.22	26.32	22.89	3.43	N	26.32	22.89	3.43	14.98%	13.03%
WHOLSALE ACCOUNT 1078481	5015454	DON	2019/05/15	2019/05/15	0	Counter Sale	22900983	1	47.66	32.82	28.54	4.28	N	32.82	28.54	4.28	15.00%	13.04%
WHOLSALE ACCOUNT 1078481	5015454	DON	2019/05/15	2019/05/15	0	Counter Sale	22900985	1	69.47	47.84	41.60	6.24	N	47.84	41.60	6.24	15.00%	13.04%
WHOLSALE ACCOUNT 1078481	5015454	DON	2019/05/15	2019/05/15	0	Counter Sale	22903540	1	42.51	29.28	25.46	3.82	N	29.28	25.46	3.82	15.00%	13.05%
WHOLSALE ACCOUNT 1078481	5015454	DON	2019/05/15	2019/05/15	0	Counter Sale	23124073	1	58.96	40.61	35.31	5.30	N	40.61	35.31	5.30	15.01%	13.05%
WHOLSALE ACCOUNT 1078481	5015454	DON	2019/05/15	2019/05/15	0	Counter Sale	23270264	1	68.21	46.98	40.85	6.13	N	46.98	40.85	6.13	15.01%	13.05%
WHOLSALE ACCOUNT 1078481	5015454	DON	2019/05/15	2019/05/15	0	Counter Sale	23278704	1	40.08	27.60	24.00	3.60	N	27.60	24.00	3.60	15.00%	13.04%
WHOLSALE ACCOUNT 1078481	5015454	DON	2019/05/15	2019/05/15	0	Counter Sale	84427117	1	631.26	351.08	378.00	-26.92	Y	351.08	378.00	-26.92	-7.12%	-7.67%
WHOLSALE ACCOUNT 1078481	5015454	DON	2019/05/15	2019/05/15	0	Counter Sale	84482384	1	60.10	41.39	35.99	5.40	N	41.39	35.99	5.40	15.00%	13.05%
WHOLSALE ACCOUNT 1078481	5015456	DON	2019/05/15	2019/05/15	0	Counter Sale	23412820	1	49.81	34.30	29.83	4.47	N	34.30	29.83	4.47	14.98%	13.03%
WHOLSALE ACCOUNT 1078481	5015529	DON	2019/05/16	2019/05/16	0	Counter Sale	84209473	1	751.44	517.47	449.97	67.50	N	517.47	449.97	67.50	15.00%	13.04%
WHOLSALE ACCOUNT 1078481	5015585	DON	2019/05/16	2019/05/16	0	Counter Sale	84134994	1	601.14	413.97	359.97	54.00	N	413.97	359.97	54.00	15.00%	13.04%
WHOLSALE ACCOUNT 1078481	5015606	DON	2019/05/17	2019/05/17	0	Counter Sale	23412820	1	49.81	34.30	29.83	4.47	N	34.30	29.83	4.47	14.98%	13.03%
WHOLSALE ACCOUNT 1078481	5015606	DON	2019/05/17	2019/05/17	0	Counter Sale	23412821	1	49.81	34.30	29.83	4.47	N	34.30	29.83	4.47	14.98%	13.03%
WHOLSALE ACCOUNT 1078481	5015617	DON	2019/05/17	2019/05/17	0	Counter Sale	22900987	1	121.34	83.56	72.66	10.90	N	83.56	72.66	10.90	15.00%	13.04%
WHOLSALE ACCOUNT 1078481	5015641	OND	2019/05/17	2019/05/17	0	Counter Return	23412820	-1	49.81	34.30	29.83	4.47	Y	-34.30	-29.83	-4.47	14.98%	13.03%
WHOLSALE ACCOUNT 1078481	5015642	DON	2019/05/17	2019/05/17	0	Counter Return	22890966	-1	38.22	26.32	22.89	3.43	Y	-26.32	-22.89	-3.43	14.98%	13.03%
WHOLSALE ACCOUNT 1078481	5015683	DON	2019/05/20	2019/05/20	0	Counter Sale	23208807	1	51.36	35.37	30.76	4.61	N	35.37	30.76	4.61	14.99%	13.03%
WHOLSALE ACCOUNT 1078481	5015683	DON	2019/05/20	2019/05/20	0	Counter Sale	23208815	1	34.88	24.02	20.89	3.13	N	24.02	20.89	3.13	14.98%	13.03%
WHOLSALE ACCOUNT 1078481	5015701	DON	2019/05/20	2019/05/20	0	Counter Return	23412820	-1	49.81	34.30	29.83	4.47	Y	-34.30	-29.83	-4.47	14.98%	13.03%
WHOLSALE ACCOUNT 1078481	5015755	DON	2019/05/21	2019/05/21	0	Counter Sale	84079820	1	19.95	13.74	11.95	1.79	N	13.74	11.95	1.79	14.98%	13.03%
WHOLSALE ACCOUNT 1078481	5015755	DON	2019/05/21	2019/05/21	0	Counter Sale	84269466	1	250.50	172.50	150.00	22.50	N	172.50	150.00	22.50	15.00%	13.04%
WHOLSALE ACCOUNT 1078481	5015792	DON	2019/05/21	2019/05/21	0	Counter Return	23208815	-1	34.88	24.02	20.89	3.13	Y	-24.02	-20.89	-3.13	14.98%	13.03%
WHOLSALE ACCOUNT 1078481	5015795	DON	2019/05/21	2019/05/21	0	Counter Sale	20969815	1	272.24	161.38	163.02	-1.64	Y	161.38	163.02	-1.64	-1.01%	-1.02%
WHOLSALE ACCOUNT 1078481	5015795	DON	2019/05/21	2019/05/21	0	Counter Sale	25881881	1	38.09	20.10	22.81	-2.71	Y	20.10	22.81	-2.71	-11.88%	-13.48%
WHOLSALE ACCOUNT 1078481	5015809	DON	2019/05/21	2019/05/21	0	Counter Sale	15129652	1	65.07	44.82	38.97	5.85	N	44.82	38.97	5.85	15.01%	13.05%
WHOLSALE ACCOUNT 1078481	5015809	DON	2019/05/21	2019/05/21	0	Counter Sale	15284308	1	250.50	172.50	150.00	22.50	N	172.50	150.00	22.50	15.00%	13.04%
WHOLSALE ACCOUNT 1078481	5015809	DON	2019/05/21	2019/05/21	0	Counter Sale	15284310	1	120.24	82.80	72.00	10.80	N	82.80	72.00	10.80	15.00%	13.04%
WHOLSALE ACCOUNT 1078481	5015809	DON	2019/05/21	2019/05/21	0	Counter Sale	15284314	1	150.30	103.50	90.00	13.50	N	103.50	90.00	13.50	15.00%	13.04%
WHOLSALE ACCOUNT 1078481	5015809	DON	2019/05/21	2019/05/21	0	Counter Sale	20885079	1	710.31	318.25	425.34	-107.09	Y	318.25	425.34	-107.09	-25.18%	-33.65%
WHOLSALE ACCOUNT 1078481	5015809	DON	2019/05/21	2019/05/21	0	Counter Sale	25792633	1	18.80	12.95	11.26	1.69	N	12.95	11.26	1.69	15.01%	13.05%
WHOLSALE ACCOUNT 1078481	5015809	DON	2019/05/21	2019/05/21	0	Counter Sale	25798300	2	75.09	51.72	44.97	6.75	N	103.44	89.94	13.50	15.01%	13.05%
WHOLSALE ACCOUNT 1078481	5015809	DON	2019/05/21	2019/05/21	0	Counter Sale	25844299	1	100.14	68.97	59.97	9.00	N	68.97	59.97	9.00	15.01%	13.05%
WHOLSALE ACCOUNT 1078481	5015809	DON	2019/05/21	2019/05/21	0	Counter Sale	25958483	1	150.30	103.50	90.00	13.50	N	103.50	90.00	13.50	15.00%	13.04%
WHOLSALE ACCOUNT 1078481	5015811	DON	2019/05/21	2019/05/21	0	Counter Sale	84132509	1	18.05	12.31	10.70	1.61	N	12.31	10.70	1.61	15.05%	13.08%
WHOLSALE ACCOUNT 1078481	5015814	DON	2019/05/21	2019/05/21	0	Counter Sale	11610383	7	4.08	2.68	2.33	.35	N	18.76	16.31	2.45	15.02%	13.06%
WHOLSALE ACCOUNT 1078481	5015842	DON	2019/05/21	2019/05/21	0	Counter Return	23412820	-1	49.81	34.30	29.83	4.47	Y	-34.30	-29.83	-4.47	14.98%	13.03%
WHOLSALE ACCOUNT 1078481	5015941	DON	2019/05/23	2019/05/23	0	Counter Sale	15284314	1	150.30	103.50	90.00	13.50	N	103.50	90.00	13.50	15.00%	13.04%
WHOLSALE ACCOUNT 1078481	5015950	DON	2019/05/23	2019/05/23	0	Counter Sale	13463244	1	111.89	73.35	63.78	9.57	N	73.35	63.78	9.57	15.00%	13.05%
WHOLSALE ACCOUNT 1078481	5015950	DON	2019/05/23	2019/05/23	0	Counter Sale	95476192	1	13.62	9.38	8.16	1.22	N	9.38	8.16	1.22	14.95%	13.01%
WHOLSALE ACCOUNT 1078481	5015987	DON	2019/05/23	2019/05/23	0	Counter Sale	11518684	4	1.82	1.25	1.09	.16	N	5.00	4.36	.64	14.68%	12.80%
WHOLSALE ACCOUNT 1078481	5015987	DON	2019/05/23	2019/05/23	0	Counter Sale	15952188	1	35.07	24.15	21.00	3.15	N	24.15	21.00	3.15	15.00%	13.04%
WHOLSALE ACCOUNT 1078481	5015987	DON	2019/05/23	2019/05/23	0	Counter Sale	15952189	1	36.67	25.25	21.96	3.29	N	25.25	21.96	3.29	14.98%	13.03%
WHOLSALE ACCOUNT 1078481	5015987	DON	2019/05/23	2019/05/23	0	Counter Sale	25783543	1	40.21	27.69	24.08	3.61	N	27.69	24.08	3.61	14.99%	13.04%
WHOLSALE ACCOUNT 1078481	5015987	DON	2019/05/23	2019/05/23	0	Counter Sale	25783544	1	40.21	27.69	24.08	3.61	N	27.69	24.08	3.61	14.99%	13.04%
WHOLSALE ACCOUNT 1078481	5015988	DON	2019/05/23	2019/05/23	0	Counter Sale	23382430	1	47.37	26.80	28.37	-1.57	Y	26.80	28.37	-1.57	-5.53%	-5.86%
WHOLSALE ACCOUNT 1078481	5015988	DON	2019/05/23	2019/05/23	0	Counter Sale	84136837	1	58.36	40.19	34.95	5.24	N	40.19	34.95	5.24	14.99%	13.04%
WHOLSALE ACCOUNT 1078481	5015988	DON	2019/05/23	2019/05/23	0	Counter Sale	84304689	1	58.36	40.19	34.95	5.24	N	40.19	34.95	5.24	14.99%	13.04%
WHOLSALE ACCOUNT 1078481	5015988	DON	2019/05/23	2019/05/23	0	Counter Sale	84324584	1	57.41	39.54	34.38	5.16	N	39.54	34.38	5.16	15.01%	13.05%
WHOLSALE ACCOUNT 1078481	5016008	DON	2019/05/24	2019/05/24	0	Counter Sale	23138227	1	19.40	13.36	11.62	1.74	N	13.36	11.62	1.74	14.97%	13.02%
WHOLSALE ACCOUNT 1078481	5016008	DON	2019/05/24	2019/05/24	0	Counter Sale	84030923	1	450.84	310.47	269.97	40.50	N	310.47	269.97	40.50	15.00%	13.04%
WHOLSALE ACCOUNT 1078481	5016008	DON	2019/05/24	2019/05/24	0	Counter Sale	84398989	1	651.30	448.50	390.00	58.50	N	448.50	390.00	58.50	15.00%	13.04%
WHOLSALE ACCOUNT 1078481	5016037	DON	2019/05/24	2019/05/24	0	Counter Sale	15040331	1	11.33	7.81	6.79	1.02	N	7.81	6.79	1.02	15.02%	13.06%
WHOLSALE ACCOUNT 1078481	5016037	DON	2019/05/24	2019/05/24	0	Counter Sale	15769308	1	23.19	15.97	13.89	2.08	N	15.97	13.89	2.08	14.97%	13.02%
WHOLSALE ACCOUNT 1078481	5016037	DON	2019/05/24	2019/05/24	0	Counter Sale	22979267	1	42.51	29.28	25.46	3.82	N	29.28	25.46	3.82	15.00%	13.05%
WHOLSALE ACCOUNT 1078481	5016037	DON	2019/05/24	2019/05/24	0	Counter Sale	23108158	1	248.01	170.79	148.51	22.28	N	170.79	148.51	22.28	15.00%	13.05%
*TOTAL CUSTKEY    1078481														6,623.12	6,086.85	536.27	8.81%	8.10%

  

This message has been edited. Last edited by: DMoyer,
 
Posts: 4 | Registered: May 21, 2019Report This Post
Virtuoso
posted Hide Post
Please use the code tag when posting sample code, layout or expected result.
It's going to be easier to read your sample and code since you will be able to align text where you want.
It's the last icon on the ribbon, the icon to click on look like the below :
</>


WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
 
Posts: 2409 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013Report This Post
Member
posted Hide Post
Thanks MartinY I Reposted it correctly
 
Posts: 4 | Registered: May 21, 2019Report This Post
Virtuoso
posted Hide Post
Thanks for the re-alignment, but you should also have your data aligned with the headers (titles) :-)

As I previously stated, you shouldn't DEFINEd MarkupPercentage and GrossPercent. Should only have them as COMPUTEs.

Try the below. Is that giving you a better result ?
I have assumed that each displayed row in you sample is unique since you display a date, line, transaction code and part. Normally from an Invoicing point of view it should be.
This gives me the opportunity to remove QTY, LIST, NET, COST, Gross and PRCOVR from the BY section because now even having them in the SUM section will display the unique value of each since each row is unique.
Then since you seems to be concerned only about having total on ExtendedNet Extended_Cost ExtendedGross MarkupPercent GrossPercent, they are the only one listed. Personally I would also add QTY (and Gross).
-DEFAULTH &WF_SUMMARY='Summary';
-DEFAULTH &WF_TITLE='WebFOCUS Report';

ENGINE INT CACHE SET ON

JOIN RWPDCLDET.RWPDCLDET.CO# AND RWPDCLDET.RWPDCLDET.INV# IN INFO_ASSIST_DATA/RWPDCLDET
TO UNIQUE RWPDCLHEAD.RWPDCLHEAD.CO# AND RWPDCLHEAD.RWPDCLHEAD.INV# IN INFO_ASSIST_DATA/RWPDCLHEAD TAG J001 AS J001
END

DEFINE FILE INFO_ASSIST_DATA/RWPDCLDET
ExtendedNet/D6.2=RWPDCLDET.RWPDCLDET.QTY * RWPDCLDET.RWPDCLDET.NET ;
ExtendedGross/D6.2=ExtendedNet - RWPDCLDET.RWPDCLDET.Extended_Cost ;
Gross/D6.2=RWPDCLDET.RWPDCLDET.NET - RWPDCLDET.RWPDCLDET.COST ;
END
TABLE FILE INFO_ASSIST_DATA/RWPDCLDET
SUM RWPDCLDET.RWPDCLDET.QTY
    RWPDCLDET.RWPDCLDET.LIST
    RWPDCLDET.RWPDCLDET.NET
    RWPDCLDET.RWPDCLDET.COST
    Gross
    RWPDCLDET.RWPDCLDET.PRCOVR
    ExtendedNet
    RWPDCLDET.RWPDCLDET.Extended_Cost
    ExtendedGross
    COMPUTE MarkupPercent/D3.2%=ExtendedGross/RWPDCLDET.RWPDCLDET.Extended_Cost * 100 ;
    COMPUTE GrossPercent/D3.2%=ExtendedGross/ExtendedNet * 100 ;
BY J001.RWPDCLHEAD.CUSTKEY NOPRINT PAGE-BREAK
BY J001.RWPDCLHEAD.FULLNAME
BY RWPDCLDET.RWPDCLDET.INV#
BY J001.RWPDCLHEAD.CPID
BY RWPDCLDET.RWPDCLDET.DATE
BY RWPDCLDET.RWPDCLDET.CLOSEDATE
BY RWPDCLDET.RWPDCLDET.LINE
BY RWPDCLDET.RWPDCLDET.TCODE NOPRINT
BY RWPDCLDET.RWPDCLDET.TRANSD
BY RWPDCLDET.RWPDCLDET.SCODE NOPRINT
BY RWPDCLDET.RWPDCLDET.PART

ON  J001.RWPDCLHEAD.CUSTKEY RECOMPUTE ExtendedNet Extended_Cost ExtendedGross MarkupPercent GrossPercent

WHERE RWPDCLDET.RWPDCLDET.CO# EQ &CO#.(OR(<BO1>,<BO2>,<BO3>,<BO4>,<BO5>,<BO7>,<BO8> |FORMAT=A3)).Company:.;
WHERE RWPDCLDET.RWPDCLDET.CLOSEDATE GE &StartDate.(|FORMAT=YYMD).Enter start date .QUOTEDSTRING;
WHERE RWPDCLDET.RWPDCLDET.CLOSEDATE LE &Enddate.(|FORMAT=YYMD).Enter end date .QUOTEDSTRING;
WHERE RWPDCLDET.RWPDCLDET.LINE NE 950 OR 996 OR 998 OR 999;
WHERE RWPDCLDET.RWPDCLDET.SCODE NE 'H' OR 'S';
WHERE RWPDCLDET.RWPDCLDET.TCODE NE 'LS';
WHERE RWPDCLDET.RWPDCLDET.PART OMITS '-C';

ON TABLE SUBHEAD
"Parts Counter Sales Report"
ON TABLE PCHOLD FORMAT XLSX
ON TABLE NOTOTAL
ON TABLE SET CACHELINES 100
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET SQUEEZE ON
ON TABLE SET HTMLCSS ON
ON TABLE SET HTMLENCODE ON
ON TABLE SET EMPTYREPORT ON
ON TABLE SET GRWIDTH 1
ON TABLE SET STYLE *

INCLUDE=IBFS:/FILE/IBI_HTML_DIR/javaassist/intl/EN/ENIADefault_combine.sty,$
TYPE=REPORT, TITLETEXT=&WF_TITLE.QUOTEDSTRING, SUMMARY=&WF_SUMMARY.QUOTEDSTRING, HFREEZE=OFF, $
TYPE=TABHEADING, LINE=1, JUSTIFY=CENTER, $
TYPE=TABHEADING, LINE=1, ITEM=1, OBJECT=TEXT, SIZE=14, STYLE=BOLD+ITALIC, $
TYPE=SUBFOOT, BY=J001.RWPDCLHEAD.CUSTKEY, LINE=1, JUSTIFY=LEFT, $
TYPE=SUBFOOT, BY=J001.RWPDCLHEAD.CUSTKEY, LINE=1, ITEM=1, OBJECT=TEXT, SIZE=10, STYLE=BOLD, $
ENDSTYLE
END
-RUN


WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
 
Posts: 2409 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013Report This Post
Member
posted Hide Post
Thank You MartinY. The code worked perfectly. It is showing me a better structure to the WF Language. As I mentioned before I am new to this and learning as I go, but I will take some time to digest the structure and see if I can now add in the code needed to calculate the return $ and %. Most of the code generated is done by their limited use GUI provided with our DealerTrack System, So I really appreciate you taking the time to rewrite.
 
Posts: 4 | Registered: May 21, 2019Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Calulate Returns and Percent

Copyright © 1996-2020 Information Builders