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] Summarize computed field using Designer 8206
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] Summarize computed field using Designer 8206
 Login/Join
 
Member
posted
Hi,
How can we summarize when in Designer Report or Chart? We are using Designer gen 1745 WF8206.
For instance recalculate DG_RATIO from Designer report or Chart as shown below.

TABLE FILE EMPLOYEE
SUM GROSS DED_AMT AND COMPUTE
DG_RATIO/F4.2=DED_AMT/GROSS;
BY HIGHEST PAY_DATE BY DEPARTMENT
BY BANK_ACCT
WHERE BANK_ACCT NE 0
ON DEPARTMENT SUMMARIZE
END

Regards

This message has been edited. Last edited by: FP Mod Chuck,


WebFOCUS 8.1
UNIX, WINDOWS
PDF, HTML
 
Posts: 11 | Registered: June 01, 2016Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Right Click Department
Click Insert Breaks
Click Recalculate totals


WebFOCUS 8206, Unix, Windows
 
Posts: 1707 | Location: New York City | Registered: December 30, 2015Reply With QuoteReport This Post
Member
posted Hide Post
Hi Babak,
I have tried as advised and it solved my problem. It was exactly what I was looking for in Designer report builder.
Grand Merci


WebFOCUS 8.1
UNIX, WINDOWS
PDF, HTML
 
Posts: 11 | Registered: June 01, 2016Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Summarize computed field using Designer 8206

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