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
July 13, 2016, 08:49 AM
Tamra
Brian,
Here are a few Focal Point links that will help out with your subtotal of an average. Not InfoAssist related however.
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
July 26, 2016, 03:05 PM
BabakNYC
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
July 30, 2016, 02:08 PM
Dan Satchell
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