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.
New TIBCO Community Coming Soon
In early summer, TIBCO plans to launch a new community—with a new user experience, enhanced search, and expanded capabilities for member engagement with answers and discussions! In advance of that, the current myibi community will be retired on April 30. We will continue to provide updates here on both the retirement of myibi and the new community launch.
What You Need to Know about Our New Community
We value the wealth of knowledge and engagement shared by community members and hope the new community will continue cultivating networking, knowledge sharing, and discussion.
During the transition period, from April 20th until the new community is launched this summer, myibi users should access the TIBCO WebFOCUS page to engage.
I just noticed something strange on the TOTAL row of a tabular report. I have 5 columns in this report. The first is hidden for sorting purposes, the second is just textual, the others are all numbers. I show the total for those three number columns. The 3rd and 5th are fine, but the 4th is showing a negative number. It makes no sense, because there are no negative numbers in that column. Moreover, if I run it as an active report and calculate the sum for the 4th column (by left clicking the column and selecting Calculate > Sum), then it calculates it correctly. Any idea why the total row is showing a negative number? And the number doesn't seem to make sense either, like its not the correct sum multiplied by -1 either, just seems to be a random negative number.
Here is the code:
TABLE FILE COST_OF_CALLS
CNT.DST.CALL_SOURCE_KEY/D12 AS 'Calls'
COMPUTE RESPONSE_TIME/D9C = DIFSEC/60/60; AS 'Total,Hours'
COST_ON_CALLS/D12M AS 'Cost of,Calls'
BY TOTAL HIGHEST COST_ON_CALLS NOPRINT
BY BY_DISPLAY AS '&BY_DISPLAY_TITLE'
WHERE MONTH_YEAR EQ '&MONTH_YEAR'
ON TABLE SUMMARIZE
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE PCHOLD FORMAT AHTML
ON TABLE SET HTMLEMBEDIMG ON
ON TABLE SET LINES 700
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
TYPE=TITLE, COLUMN=N3, JUSTIFY=RIGHT,$
TYPE=TITLE, COLUMN=N4, JUSTIFY=RIGHT,$
TYPE=TITLE, COLUMN=N5, JUSTIFY=RIGHT,$
I realize you will not be able to run that code, sorry. But it might be helpful.
Also, in case this is important, the 4th column shows -579,182 on the TOTAL row. When I do Calculate > Sum, I get 613,871.
Thanks folks!This message has been edited. Last edited by: Shingles,