TABLE FILE FUNDING SUM BUDGET_AMT/P21C AS 'Budget' BY LOWEST ACT_CD AS 'Budget ,Activity' ACROSS HIGHEST BDGT_FY AS 'Fiscal Year' WHERE Service_Name EQ 'IT'; ON TABLE SET PAGE-NUM NOLEAD ON TABLE NOTOTAL ON TABLE PCHOLD FORMAT HTML
For an example display output: Fiscal, Year 2012 2011 2010 2009 200 500 800 999 <<--all budget for each year
But how can I write code to to find a diff between budget year. I'm still struggle how to hold value.
Fiscal Year 2012 2011 2010 2009 Budget 200 500 300 900 diff: -300 (budget year 2012 - budget year 2011) diff: 200 (budget year 2011 - budget year 2010) diff: -600 (budget year 2010 - budget year 2009)
Thanks in advance DavidThis message has been edited. Last edited by: Kerry,
Webfocus 7.7.02, Win 7,Pdf, Excel, HTML
October 28, 2011, 02:24 PM
Doug
Training... Training... Training... It's in the WebFOCUS 101 manuals...
BUt, check this out for starters: DEFINE last years / this years values and use them in your "difference" formula... Then show the results...
October 28, 2011, 02:54 PM
DTIC
Oh no... I wish my company send me to training. Keep digging documents and self learner Webfocus. but don't know how to construct code. If anyone has simple code how to do it that will helps.
Thanks David
Webfocus 7.7.02, Win 7,Pdf, Excel, HTML
October 30, 2011, 04:34 PM
Waz
Some hints....
Its all in the order and looking for the LAST value to do the calc.
Waz...
Prod:
WebFOCUS 7.6.10/8.1.04
Upgrade:
WebFOCUS 8.2.07
OS:
Linux
Outputs:
HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!
October 31, 2011, 09:25 AM
DTIC
Thank you for your hints. I need define temp variable and LAST and COMPUTE functions to do calculation. Thanks