"APPLICATION PORTFOLIO PLANNING REPORT ON TABLE SET PAGE-NUM OFF ĬOMPUTE PCNTS/D12.2 = ( SALESX / TOTAL_NO_APPS ) * 100 NOPRINTĬOMPUTE PCNTA/D12.2 = ( SALESX / TOTAL_NO_APPS ) * 100
#GRANDTOTAL APP CODE#
This sounds simple.but i have been tryin this for the past 1 week.īelow is the code which shows the structure of the report. adn i am not able to format the title and font of the compute column and synchronize the font with the rest of the report structure. I have 2 compute columns which are to be displayed at the end of a CROSSTAB report. I can get this to work no problem if individual columns are on a report but not when the columns are generated repeatedly as in the original example It doesn't even work if you conditional format the Totals in Resource painter. There just doesn't seem to be anything logical,Īll I want to do is format the items in the Totals that are below zero to Red. (FOC3219) A SINGLE COLUMN MUST BE SPECIFIED (FOC3202) BAD VALUE IN STYLESHEET FILE AT LINE WHEN = TOTAL(Var) LT 0 it returns an Error Use ROWTOTAL(*) to select all row total columns in the report.įormat the whole totals row as red including the word TOTAL ! Use ROWTOTAL(field) to select the row total column for a particular field. Use ROWTOTAL(n) to select a particular total column. When used with ACROSS and multiple display commands, ROWTOTAL generates multiple total columns. ROWTOTAL Identifies a column of row totals generated using ROW-TOTAL. Or field(*) to select all occurrences of the field.
When a field occurs more than once, use field(n) to select a particular occurrence To determine the value of n, count only vertical sort (BY) fields,įield Identifies a column by its field name. Do not count vertical sort (BY) fields or ROW-TOTAL fields.īn Identifies a vertical sort (BY) column by its position in the report. To determine the value of n, count only display fields from left to right, To determine the value of n, count vertical sort (BY) fields,ĭisplay fields, and ROW-TOTAL fields from left to right.Ĭn Identifies a display column by its position in the report. Pn Identifies a column by its position in the report. To determine this value, count vertical sort (BY) fields,ĭisplay fields, and ROW-TOTAL fields, from left to right, Nn Identifies a column by its position in the report. To answer the first 2 these are the guide lines So I now want to format the GRANDTOTAL using CSSįirst question, is there any defined ways to identify which column, ( N1, N2 N3 etc ) or is it purely in order so in this caseĢndly in the above example, when setting the Column to Var, only the first item would change to red when LT, the others remained the normal formatting.ģrdly, is there anyway to set the CSS style formating and define the fields inside the Report Painter ? Should be simple enough to do but its giving me a headacheĬOMPUTE Actual/F5 = ( CHGPT101 / CHGPT201 ) * 100 NOPRINTĬOMPUTE TgtCalcC/F5 = TgtCalcA / TgtCalcB NOPRINT AS 'Target'ĬOMPUTE Var/F5 = Actual - TgtCalcC AS 'Variance' 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.ĭuring the transition period, from April 20th until the new community is launched this summer, myibi users should access the TIBCO WebFOCUS page to engage. What You Need to Know about Our New Community
We will continue to provide updates here on both the retirement of myibi and the new community launch. 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. You'll continue to have access to this treasure trove of knowledge, for search purposes only. We value the wealth of knowledge that's been shared here over the years. As of December 1, 2020, Focal Point is retired and repurposed as a reference repository.