 |
|||||
|
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. | |||||
Page 1 2
Go  | Search | Tools |
| [SOLVED] PCT. WITHIN Rounding Issue (in WebFOCUS/FOCUS Forum on Focal Point ) by Anatess to round out properly to the closest integer using PCT. WITHIN. SET DMPRECISION = 0 doesn't seem to ... code: TABLE FILE HOLD SUM SNAG_COUNT/I9 AS '' PCT.SNAG_COUNT/I3% WITHIN CHKLST_TYPE AS '' BY ... actual value is 37.6726. PCT.SNAG_COUNT truncates the decimals instead of rounding it. How do I get... Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point
RE:
Can InfoAssit do this? (in WebFOCUS/FOCUS Forum on Focal Point ) by Doug,PRODUCT,LEVEL' DOLLARS/D20 WITHIN REGION AS 'DOLLARS,WITHIN,REGION' DOLLARS/D20 WITHIN CATEGORY AS 'DOLLARS,WITHIN,CATEGORY' DOLLARS/D20 WITHIN PRODUCT AS 'DOLLARS,WITHIN,PRODUCT' COMPUTE PCT_DOL_REG/D12% = (TOT.DOLLARS / DOLLARS) * 100 ; AS 'PCT,DOL,REG' COMPUTE TOT_DOL_CAT/D12.2 = IF CATEGORY... Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point
RE:
Average of PCT across a field (in WebFOCUS/FOCUS Forum on Focal Point ) by mgrackinBecause you are taking an average of the PCT values, you need to HOLD the data first and then use a multi-verb request with a COMPUTE after the ACROSS to get what you want.TABLE FILE CARSUM PCT.RETAIL_COST WITHIN COUNTRYBY COUNTRYBY BODYTYPEON TABLE HOLD AS THEDATAEND-RUNTABLE FILE THEDATASUM AVE... Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point
RE:
[CLOSED]Graphing help ( Bubble chart) (in WebFOCUS/FOCUS Forum on Focal Point ) by Tony Aquote:Awesome come Tony A.Thanks Ricardo I am guessing that you meant code in your comment For info, you could achieve the output from your example in the following manner -TABLE FILE IBISAMP/CAR SUM SALES WITHIN TABLE NOPRINT SALES COMPUTE PCT/D8.2 = C2 / C1 * 100; BY COUNTRY... Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point
RE:
[CASE-OPENED] Does multi-verb always result in multi-line subtotals? (in WebFOCUS/FOCUS Forum on Focal Point ) by Reg.Tquote:The report runs through until I add a single line with PCT.field /fmt WITHIN group, and then ... cause is the space between the field and /fmt elements, and the solution is to write it as PCT.field ... my reports shows a combination of sales and forecasts by week over a half-year. The PCT solution... Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point
RE:
[ALWAYS OPEN] Calculating Percentages with Across and By (in WebFOCUS/FOCUS Forum on Focal Point ) by Huaby-field total PCT.CNT_UBN_ID/D6.2 WITHIN RRS_OSFI_REF AS '' -* This works when calculating the percentage across -* % over by-field total(WITHIN higher by-field is assumed) PCT.CNT_UBN_ID/D ... ) PCT.CNT_UBN_ID/D6.2 WITHIN P2_MS_RR_NAME_SHORT AS '' -* This works when calculating the... Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point
RE:
[ALWAYS OPEN] Calculating Percentages with Across and By (in WebFOCUS/FOCUS Forum on Focal Point ) by Francis MarianiI am back to the PCT ACROSS BY problem FIVE years later!!!SET PAGE=NOPAGE DEFINE FILE CAR REGION/A ... TABLE FILE CAR SUM PCT.DSALES AS '' BY REGION PAGE-BREAK BY COUNTRY ACROSS SEATS AS '' END Results ... GERMANY . 10 100 I thought I could control that by WITHIN, but the WITHIN field is not REGION... Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point
RE:
[CLOSED] ACROSS and RECOMPUTE Issue (in WebFOCUS/FOCUS Forum on Focal Point ) by ChaudharyHi AMC,Are you looking something like this ? TABLE FILE CAR SUM CNT.CAR.CARREC.MODEL AS 'MODELCNT' CNT.CAR.CARREC.MODEL WITHIN TABLE AS 'TOTCNT' BY CAR.COMP.CAR BY COUNTRY ON TABLE SET PAGE ... /endeflt.sty, $ ENDSTYLE END TABLE FILE CNT_TOCNT SUM MODELCNT TOTCNT COMPUTE PCT/D12.2% = MODELCNT... Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point [SOLVED] ACROSS, COMPUTE AND STYLES (in WebFOCUS/FOCUS Forum on Focal Point ) by José Andrés Vargas AguilarCARSUM SALESD AS 'Sales'PCT.SALESD/D6.2 WITHIN COUNTRY WITHIN SEATS AS '%'BY COUNTRY NOPRINTBY CARACROSS SEATSCOMPUTE XTOT_SALESD/D15 = C2; AS 'Total'COMPUTE PCT/D12.2 = C2 / C1 * 100; AS... Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point
RE:
PCT. and ACROSS and ROW-TOTAL and ACROSS-TOTAL and COLUMN-TOTAL (Here I go again!) (in WebFOCUS/FOCUS Forum on Focal Point ) by mgrackinAS 'Sales'PCT.SALESD/D6.2% WITHIN COUNTRY WITHIN SEATS AS '%'BY COUNTRY NOPRINTBY CARACROSS SEATSCOMPUTE XTOT_SALESD/D15 = C1; AS 'Total'COMPUTE PCT/D12.2 = C2; AS '%'ON COUNTRY SUBHEAD"COUNTRY... Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point
RE:
[SOLVED]NOPRINT RECAP to place in SUBFOOT (in WebFOCUS/FOCUS Forum on Focal Point ) by FreSteCOMPUTE PCT1/D8.2 = (QTY/C1) * 100; AS 'Pct within ...,DEP' COMPUTE PCT2/D8.2 = (QTY/TOT.QTY) * 100; AS 'Pct within ...,TOTAL ALL' BY DEP COLUMN-TOTAL BY COMCLASS SUB-TOTAL ON... Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point
RE:
[CLOSED]GRAND TOTAL FORMAT (in WebFOCUS/FOCUS Forum on Focal Point ) by vaayu. SHould I be controlling this within the STYLE? -SET &COUNT_FIELD = IF &AGEOPT EQ 0 THEN 'PARTICIPANTS ... = AS 'Balance' COMPUTE BAL_PCT/D12.3% = PCT. AS 'Percent of Total' BY LOWEST PLANASSET.SEG ... 01.ASSET_CATEGORY SUBFOOT "TTLASS +0 ST.BAL_AMTST.BAL_PCT" ON PLANASSET.SEG01.LEGAL_NM SUBFOOT... Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point
RE:
[SOLVED] Cant get my counter to work (in WebFOCUS/FOCUS Forum on Focal Point ) by tlbrydie"SYNOVUS MORTGAGE CORP""FHA-VA Loans Insured Within 60 Days of Closing Metric ""Report Date Range ... SUBFOOT -*SUBHEAD SUBFOOT " " "Number of Loans:""Total Loans passed:""PCT of Loans passed:""Total Loans Fail:""PCT of Loans Fail:"... Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point
RE:
[SOLVED] Cant get my counter to work (in WebFOCUS/FOCUS Forum on Focal Point ) by tlbrydieName: PC - FHA - VA Loans Insured Within 60 Days of Closing Metric - 2860 *-* Deccription: This Report is at the Loan Level *-* PC - FHA - VA Loans Insured Within 60 Days of Closing Metric ... PERCENTFAIL HEADING"SYNOVUS MORTGAGE CORP""FHA-VA Loans Insured Within 60 Days of Closing Metric... Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point
RE:
[HELP!] How to ensure that percentages add up to 100% (in WebFOCUS/FOCUS Forum on Focal Point ) by Francis Mariani9 = 1; PRODUCT/A10 = IF PROD_NUM EQ '1036' THEN 'OTHER' ELSE PROD_NUM; END -RUN TABLE FILE CENTORD SUM PCT.ORDER_COUNT/D6.2 WITHIN QUARTER AS 'PCT_CNT' BY PLANT BY QUARTER BY PRODUCT ON TABLE HOLD AS H ... 100 -* This is necessary due to an idiosyncrasy regarding PCT.: -* The... Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point
RE:
Reserved Words (in WebFOCUS/FOCUS Forum on Focal Point ) by JGWITHIN CHANGE EQ INT OFFLINE SCAN WRITE CHECK ... FIN LINES PAUSE STORE CONSULT FINISH LINK PCT... Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point
RE:
[SOLVED] Would anyone here know of poss. causes of this error?: (in WebFOCUS/FOCUS Forum on Focal Point ) by CoolGuyrecognize a DEFINE field/word used in a WHERE clause within the code (SELL). Or at least that is what ... ' PCT.&S1/P12.2% AS 'Mix' QTY/P15C AS 'InvUnits' DRPQTY/P15C AS 'Drop,InvUnits' BY Mbr AS ... ' PCT.&S1/P12.2% AS 'Mix' QTY/P15C AS 'InvUnits' DRPQTY/P15C AS 'Drop,InvUnits' BY Mbr AS '' BY... Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point | » Refine Search » New Search |
| Powered by Social Strata | Page 1 2 |
 | Please Wait. Your request is being processed... |
Copyright © 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 |