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     ROW-TOTAL double counts the ACROSS-TOTAL
Go
New
Search
Notify
Tools
Reply
  
ROW-TOTAL double counts the ACROSS-TOTAL
 Login/Join
 
Expert
posted
anyone having any luck with ACROSS-TOTAL?
it creates subtotals of columns but then the grand ROW-TOTAL is DOUBLE the proper value. Argh!
TABLE FILE CAR
SUM SALES OVER SEATS
ACROSS CAR AS ' '
ACROSS MODEL AS ' ' ACROSS-TOTAL AS 'Mtot'
AND ROW-TOTAL AS GRAND
BY COUNTRY
END
---
ah! Noreen just explained it to me;
first, dont use Row-Total with Across-total.
Second,
ACROSS CAR AS ' ' ACROSS-TOTAL AS 'grand'
ACROSS MODEL AS ' ' ACROSS-TOTAL AS 'Mtot'
.. the first acrosstotal is the replacement
... for row-total. you need to use both.
... ah! now i get it.
 
Posts: 3811 | Location: Manhattan | Registered: October 28, 2003Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     ROW-TOTAL double counts the ACROSS-TOTAL

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