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     [Closed] EXCEL's =SUBTOTAL(9,range) function
Go
New
Search
Notify
Tools
Reply
  
[Closed] EXCEL's =SUBTOTAL(9,range) function
 Login/Join
 
Member
posted
Is it possible to create EXCEL's '=SUBTOTAL(9,range)' function in WebFOCUS and pass it to EXCEL?

I have tried 'ON TABLE PCHOLD FORMAT XLSX FORMULA' with Column-TOTAL & SUBTOTAL but it only creates a '=SUM' function.

I know I could use a Template, but I am looking for a way where that wouldn't be necessary.

Any and all suggestions would be helpful.

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


WF 8.2.01M, MF MVS 7.6.5
 
Posts: 28 | Location: Milwaukee, WI | Registered: September 10, 2008Reply With QuoteReport This Post
Virtuoso
posted Hide Post
None from I know except using an Excel Macro Template


WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
 
Posts: 2296 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013Reply With QuoteReport This Post
Master
posted Hide Post
quote:
Originally posted by MartinY:
None from I know except using an Excel Macro Template


That's how I do it. I allow space for the subtotals in the report, generally at the top between the Page/Report Heading and Column Titles. Then I use Auto_Open macro to insert the formula and copy it to other cells if needed. I use Auto_Open macros in 95% of our Excel Reports to do things WebFOCUS doesn't do or at least doesn't do easily.


In FOCUS since 1985. Prod WF 8.0.08 (z90/Suse Linux) DB (Oracle 11g), Self Serv, Report Caster, WebServer Intel/Linux.
 
Posts: 950 | Location: Oklahoma City | Registered: October 27, 2006Reply With QuoteReport This Post
Expert
posted Hide Post
Good One That's the best, if not only, solution.

Excel Macro Template




   In FOCUS Since 1983 ~ from FOCUS to WebFOCUS.
   Currently with Fidelity Investments
 
Posts: 3066 | Location: Middle Tennessee [8204M Gen48 in Test&Prod] | Registered: February 23, 2005Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [Closed] EXCEL's =SUBTOTAL(9,range) function

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