Focal Point Banner


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.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Excel Formula - A Cell which displays Formula

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED] Excel Formula - A Cell which displays Formula
 Login/Join
 
SauPa
Member
posted
Code ( From a WebFocus Sample)

TABLE FILE SHORT
HEADING
"Projected Return Across Continent"
" "
SUM PROJECTED_RETURN AS 'RETURN' AND BALANCE AS 'BALANCE'
ACROSS CONTINENT AS 'CONTINENT'
BY REGION AS 'REGION'
ON CONTINENT ROW-TOTAL AS 'TOTAL'
ON TABLE COLUMN-TOTAL AS 'TOTAL'
ON TABLE SET STYLE *
TYPE=REPORT, COLOR=BLUE, BACKCOLOR=SILVER, SIZE=9,$
TYPE=HEADING, STYLE=BOLD, SIZE=14, $
TYPE=TITLE, STYLE=BOLD, SIZE=11,$
TYPE=SUBTOTAL,STYLE=BOLD, $
TYPE=GRANDTOTAL,STYLE=BOLD,SIZE=11,$
TYPE=ACROSSTITLE,STYLE=BOLD,SIZE=11,JUSTIFY=LEFT,$
TYPE=ACROSSVALUE,STYLE=BOLD,SIZE=10,JUSTIFY=CENTER,$
ENDSTYLE
ON TABLE PCHOLD FORMAT EXL2K FORMULA
END

Output -- Creates Columns H and I in the report which have the formula Cells.


Desired Output --
I want to modify this example to include another column J which should show the formula that adds the values in Column H + Column I.


Problem Statement -
While I can compute the sum of two values which in turn are the results of an Excel Formula.
I am not able to have the result displayed as a formula in Excel.
How Can I use Excel Functions such as Indirect ( that reference other cells)....

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


Saurabh Palkar
 
Posts: 18 | Registered: April 20, 2007Report This Post
<JG>
posted
You have to use an Excel template/macro to do that.

Or simply compute another column that contains the formula as text.

COMPUTE FORMULA/A20='=(A1+D2)/X26';
 
Report This Post
FrankDutch
Virtuoso
posted Hide Post
Saurabh

How can you be sure it's always column H and I you want to sum.

Why do you want this to be done with Excel?
What is the advantage?




Frank
prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7

 
Posts: 2387 | Location: Amsterdam, the Netherlands | Registered: December 03, 2006Report This Post
SauPa
Member
posted Hide Post
FrankDutch,

The advantage is in creation of calculators of certain logic.

I am creating a report that displays financial claims reports. A few initial values in the computation are obtained as is from the database. The rest are to displayed and done in Excel Formulae.

Our users would like to know the impact of changing certain values ( obtained from the database) on the net result.

Hence they not only want to sum up 2 columns that already contain other formula, but also want to that to be displayed.

So in the current example let us assume H and I as the columns the user would like to add.

Please note:- This example is only for purposes of discussion.

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


Saurabh Palkar
 
Posts: 18 | Registered: April 20, 2007Report This Post
SauPa
Member
posted Hide Post
JG,
I think the idea to have the formula itself as a compute result is interesting.
But what about the references ? i.e. # for rows and columns....

In my case I want them add values of Column H, row aRow (say)....

How will I manipulate that ?


Saurabh Palkar
 
Posts: 18 | Registered: April 20, 2007Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Excel Formula - A Cell which displays Formula

Copyright © 1996-2020 Information Builders