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     Column-totals for compute
Go
New
Search
Notify
Tools
Reply
  
Column-totals for compute
 Login/Join
 
Silver Member
posted
Hello,

I am using a where condition on compute field to filter top 50% records/orders

a) I am creating a report with column totals.
Totals are split in two lines(since I am using no print for BY field).

Problem:
everything works fine except totals are split in two lines

OR

b) To avoid splitting I started using subfoot(using tot.fieldname).
Problem:
Totals don't change on filter.
I mean it adds all the records without considering the filter on compute field.

I would appreciate if anyone can assist me in fixing either 'a' or 'b'

Thanks,
SG.


Webfocus 7.6.8
PDF,HTML & EXCEL
 
Posts: 32 | Location: memphis,tn | Registered: January 25, 2007Reply With QuoteReport This Post
Expert
posted Hide Post
There's a pile of postings here on SUBTOTAL lines getting split into two - I'd suggest reading those to solve the problem rather than using SUBFOOT.


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Reply With QuoteReport This Post
Platinum Member
posted Hide Post
HI SG

can u show the exact o/p picture ...


WebFOCUS 7610
Windows
 
Posts: 121 | Registered: September 25, 2007Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Column-totals for compute

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