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. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at email@example.com and provide your corporate email address, company, and name.
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.
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,
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, 2015