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] RECOMPUTE Column total of AVG %

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED] RECOMPUTE Column total of AVG %
 Login/Join
 
Brian Baird
Member
posted
Good afternoon.

Hopefully a simple one. All of the below is in InfoAssist 8.1.05.

I have a report that takes a standard numeric field and sets aggregation to AVG. The row elements in the report are correct but the column total is summing the average of all rows and not giving the actual average of the aggregated data.

e.g.


TABLE FILE xxx/xxxx
SUM
AVE.MUSCATSCR
BY AGENT_ID
BY AGT_NAME
BY SKILL
ON TABLE PCHOLD FORMAT HTML
ON TABLE RECOMPUTE
END



How do I get the column total to also be the AVG?

Many Thanks
Brian.

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


WebFOCUS 7 & 8
Windows, All Outputs
 
Posts: 16 | Registered: September 03, 2014Report This Post
Tamra
Guru
posted Hide Post
Brian,

Here are a few Focal Point links that will help out with your subtotal of an average. Not InfoAssist related however.

Get the Total of Sub-Total averages


Average In Footer

You can also compute the average and then put this field into a SUB FOOTER then the column invisible.

With not really knowing the data you could try adding into the summary (Compute) window:
MUSCATSCR / CNT.MUSCATSCR

Then add the new field into the Subfoot line. Here is a link with coding for this:
Adding an average line after grand totals

Thank you for participating in the Focal Point Forum.

Kindest regards,
Tamra Colangelo
Focal Point Moderator - Information Builders Inc.


WebFOCUS 8x - BI Portal, Developer Studio, App Studio, Excel, PDF, Active Formats and HTML5
 
Posts: 487 | Location: Toronto | Registered: June 23, 2009Report This Post
BabakNYC
Virtuoso
posted Hide Post
In InfoAssist, Home tab, look for Column Totals on the right of your screen, click the drop down for Column Totals and pick More Options, select Recomputed radio button and then look at the Prefix and change it from Sum to Average.


WebFOCUS 8206, Unix, Windows
 
Posts: 1853 | Location: New York City | Registered: December 30, 2015Report This Post
Dan Satchell
Virtuoso
posted Hide Post
I believe you will need to explicitly perform the calculation if you want it RECOMPUTEd for the TOTALs line.

TABLE FILE CAR
 SUM
  AVE.SALES
  COMPUTE AVG_SALES/I6 = SALES / CNT.SALES ;
 BY COUNTRY
 WHERE SALES NE 0 ;
 ON TABLE RECOMPUTE
END


WebFOCUS 7.7.05
 
Posts: 1213 | Location: Seattle, Washington - USA | Registered: October 22, 2007Report 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] RECOMPUTE Column total of AVG %

Copyright © 1996-2020 Information Builders