 |
|||||
|
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
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 WebFOCUS/FOCUS Forum on Focal Point [Solved] Referencing table cells when using SUM OVER ACROSS
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [Solved] Referencing table cells when using SUM OVER ACROSS Read-Only TopicGo | Search | Notify | Tools |
| [Solved] Referencing table cells when using SUM OVER ACROSS | Login/Join |
| Silver Member |
I have a table that has titles going horizontally on the first row and titles going vertically on the first column. The data cells are made up of counts that are links to another focexec. The problem is that I do not know how to reference the individual data cells. Can anyone give me some guidance? I can provide some code if that helps. Thanks...This message has been edited. Last edited by: slim007, 7.1.4 UNIX Excel, PDF, HTML | ||
|
| Expert |
slim, Search on ACROSSVALUE Tom Tom Flynn WebFOCUS 8.1.05 - PROD/QA DB2 - AS400 - Mainframe | |||
|
| Platinum Member |
If you are talking about referencing them in stylesheets, you could also try the FIELD=Px notation, where 'x' would be numerical number representing the order of Printed columns. If you are not sure of the exact order, experiment with the following lines by changing the 'x' value to figure out how FOCUS is treating the cells in the background - TYPE=DATA,COLUMN=P1,BACKCOLOR=YELLOW,$ TYPE=DATA,COLUMN=P2,BACKCOLOR=RED,$ TYPE=DATA,COLUMN=P3,BACKCOLOR=GREEN,$ ....etc.... Sandeep Mamidenna ------------------------------------------------------------------------------------------------- Blue Cross & Blue Shield of MS WF.76-10 on (WS2003 + WebSphere) / EDA on z/OS + DB2 + MS-SQL MRE, BID, Dev. Studio, Self-Service apps & a dash of fun !!  | |||
|
| Silver Member |
BlueZone, I'm running into another problem. I have links for each cell for my across columns and I have a "WHEN=fieldname GT 0". So, the links only show up when the count is greater than zero. However, for some reason the link still shows up for some of the zero counts. Do you have any solution? Thanks... 7.1.4 UNIX Excel, PDF, HTML | |||
|
| Virtuoso |
You may have the Columns referenced wrong. Try setting them to different colors so you can see which one is really which.
| |||||
|
| Silver Member |
Using the Px notation, I get the row for that columns I have. Do you know how to reference a particular cell? I have a table with 7 columns and 17 rows. Thanks... 7.1.4 UNIX Excel, PDF, HTML | |||
|
| Expert |
Slim, For multiple columns the syntax is usually TYPE=what ever, COLUMN=column(*), etc. etc. Not sure if you can use a numeric instead of the asterisk but you could try it out. I can't test it at home. T
| |||||||||
|
| Virtuoso |
Is this something like what you are trying to do? TABLE FILE CAR SUM RCOST OVER DCOST OVER SALES BY MODEL ACROSS BODYTYPE ON TABLE SET STYLE * TYPE=DATA, ACROSSCOLUMN=SALES, BACKCOLOR=GREEN, COLOR=WHITE, WHEN=SALES GT 0,$ ENDSTYLE END Thanks! Mickey
| |||||
|
| Silver Member |
Mickey, This is exactly what I am trying to do. However, for some reason even though the column value, in your example "Sales" is 0, the "WHEN" does not work. Could there be some other value that could be overriding the 0? I am at a loss... Thanks... 7.1.4 UNIX Excel, PDF, HTML | |||
|
| Virtuoso |
Slim Can't you post some code? We might see what is wrong and an example of the report you need might help too. Create it in excel , make a screen print and show it.
| |||||||
|
| Virtuoso |
I have had trouble Making across work like this before. This is how I made it work. Referencing CW in an Acrosscolumn would not work. TYPE=DATA,COLOR='RED',COLUMN=N10,WHEN=CW LT 0,$ TYPE=DATA,COLOR='RED',COLUMN=N11,WHEN=CW LT 0,$ TYPE=DATA,COLOR='RED',COLUMN=N13,WHEN=CW LT 0,$ TYPE=DATA,COLOR='RED',COLUMN=N12,WHEN=CW LT 0,$ TYPE=DATA,COLOR='RED',COLUMN=N16,WHEN=CW LT 0,$ | |||
|
| Virtuoso |
slim, Does it work properly with the CAR file? Thanks! Mickey
| |||||
|
| Silver Member |
I finally got it work! Thanks for all your help!  Here is what my code looks like: TYPE=DATA,COLOR='RED',ACROSSCOLUMN=N10,WHEN=N10 GT 0,$ Thanks Again! 7.1.4 UNIX Excel, PDF, HTML | |||
|
| Virtuoso |
Well now that is interesting. | |||
|
| Virtuoso |
slim, That's good to here. Please edit the original post you started this thread with and add [SOLVED] to the subject title. FYI, you can also use the fieldname in the ACROSSCOLUMN= statement and it should work as well AS LONG AS the fieldname is not referecned more than once in the SUM statement. Thanks! Mickey
| |||||
|
| Virtuoso |
What a great peice of information...I was driving my self crazy with an Across - and a red negative. I had SUM NEWCOST BY HIGHEST TOTAL NEWCOST ACROSS SMARTDATE and it was not working...read this helpful hint below...redefined the second NEWCOST to a different name....and it works! Thanks Mickey
| |||
|
| Powered by Social Strata |
 | Please Wait. Your request is being processed... |
Read-Only TopicFocal Point Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [Solved] Referencing table cells when using SUM OVER ACROSS
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [Solved] Referencing table cells when using SUM OVER ACROSSCopyright © 1996-2020 Information Builders
| View $GS_USERNAME's Public Profile |
| Add $GS_USERNAME to my Ignore List |
| View Recent Posts by $GS_USERNAME |
| Notify me of New Posts by $GS_USERNAME |