Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED]Compare COLUMN-TOTALs
Go
New
Search
Notify
Tools
Reply
  
[SOLVED]Compare COLUMN-TOTALs
 Login/Join
 
Silver Member
posted
I need to compare the values of two column totals. In this example I would like to set the color of the greater value of (total) DEALER_COST and (total) RETAIL_Cost.

TABLE FILE CAR
SUM
     CAR.BODY.DEALER_COST
     CAR.BODY.RETAIL_COST
BY  CAR.COMP.CAR
ON TABLE COLUMN-TOTAL AS 'TOTAL'
END  


Thanks, David

This message has been edited. Last edited by: David M,


WebFOCUS 8.1.05M, 8.2.02M
Windows, All Outputs
 
Posts: 34 | Location: Southern New Jersey | Registered: January 24, 2017Reply With QuoteReport This Post
Platinum Member
posted Hide Post
 TABLE FILE CAR
SUM 
     CAR.BODY.DEALER_COST
     TOT.CAR.BODY.DEALER_COST NOPRINT
     CAR.BODY.RETAIL_COST
     TOT.CAR.BODY.RETAIL_COST NOPRINT
BY  CAR.COMP.CAR
ON TABLE COLUMN-TOTAL AS 'TOTAL'
ON TABLE SET STYLE *
TYPE = DATA ,
COLUMN=N2,
COLOR = 'RED',
WHEN=N3 LT N5,
$
ENDSTYLE
END
 


WF Production :- WF:8.0.0.4, 8.1.05 App-studio/Developer Studio(8.1.x) ,
8.2.0.1M , 8.2.0.2 (App-Studio8.2.x),
InfoAssist/+, InfoDiscovery
Output format:-AHTML, PDF, Excel, HTML
Platform:-Windows 7, 8,10
 
Posts: 186 | Location: Infobuild India | Registered: August 28, 2015Reply With QuoteReport This Post
Silver Member
posted Hide Post
Thank you for your response, but I am trying to highlight just the TOTAL amount not the whole column.


WebFOCUS 8.1.05M, 8.2.02M
Windows, All Outputs
 
Posts: 34 | Location: Southern New Jersey | Registered: January 24, 2017Reply With QuoteReport This Post
Virtuoso
posted Hide Post
TABLE FILE CAR
SUM 
     CAR.BODY.DEALER_COST
     TOT.CAR.BODY.DEALER_COST NOPRINT
     CAR.BODY.RETAIL_COST
     TOT.CAR.BODY.RETAIL_COST NOPRINT
BY  CAR.COMP.CAR
ON TABLE COLUMN-TOTAL AS 'TOTAL'
ON TABLE SET STYLE *
TYPE = GRANDTOTAL,
COLUMN=N2,
COLOR = 'RED',
WHEN=N3 LT N5,
$
ENDSTYLE
END


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: 2341 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013Reply With QuoteReport This Post
Silver Member
posted Hide Post
Works perfectly, thanks.


WebFOCUS 8.1.05M, 8.2.02M
Windows, All Outputs
 
Posts: 34 | Location: Southern New Jersey | Registered: January 24, 2017Reply With QuoteReport This Post
Platinum Member
posted Hide Post
quote:
TABLE FILE CAR
SUM
CAR.BODY.DEALER_COST
TOT.CAR.BODY.DEALER_COST NOPRINT
CAR.BODY.RETAIL_COST
TOT.CAR.BODY.RETAIL_COST NOPRINT
BY CAR.COMP.CAR
ON TABLE COLUMN-TOTAL AS 'TOTAL'
ON TABLE SET STYLE *
TYPE = GRANDTOTAL,
COLUMN=N2,
COLOR = 'RED',
WHEN=N3 LT N5,
$
ENDSTYLE
END

we can use WHEN condition on total directly
 TABLE FILE CAR
SUM 
     CAR.BODY.DEALER_COST
      CAR.BODY.RETAIL_COST
BY  CAR.COMP.CAR
ON TABLE COLUMN-TOTAL AS 'TOTAL'
ON TABLE SET STYLE *
    INCLUDE = IBFS:/EDA/EDASERVE/_EDAHOME/ETC/warm.sty,
$
TYPE = GRANDTOTAL,
COLUMN=N3,
COLOR = 'GREEN',
WHEN=N3 GT N2,
$
ENDSTYLE
END 


WF Production :- WF:8.0.0.4, 8.1.05 App-studio/Developer Studio(8.1.x) ,
8.2.0.1M , 8.2.0.2 (App-Studio8.2.x),
InfoAssist/+, InfoDiscovery
Output format:-AHTML, PDF, Excel, HTML
Platform:-Windows 7, 8,10
 
Posts: 186 | Location: Infobuild India | Registered: August 28, 2015Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED]Compare COLUMN-TOTALs

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.