Is it possible to exclude a child in the output when using the hierarchy to drive the output?
For example with this code:
SET FORMULTIPLE = ON
JOIN SYS_ACCOUNT IN CENTGL TO ALL SYS_ACCOUNT IN CENTSYSF
TABLE FILE CENTGL
SUM
NAT_AMOUNT/D10.0
NAT_YTDAMT/D10.0
FOR GL_ACCOUNT
2000 GET CHILDREN 1 ADD AS CAPTION OVER
BAR OVER
2000 ADD AS CAPTION LABEL GROSS OVER
BAR OVER
3000 GET CHILDREN 2 ADD AS CAPTION OVER
BAR OVER
3000 ADD AS CAPTION LABEL EXP OVER
BAR AS = OVER
RECAP TOTAL = GROSS + EXP; AS 'TOTAL'
IF PERIOD EQ '2002/03'
END
The output is:
PAGE 1
Month Actual YTD Acutal
Revenue -10,398,305. -30,877,546.
Cost Of Goods Sold 5,884,646. 17,796,997.
Gross Margin -4,513,659. -13,080,549.
Selling Expenses 1,554,319. 4,451,098.
Advertising 1,303,277. 3,705,368.
Promotional Expenses 53,719. 151,732.
Joint Marketing 97,135. 289,799.
Bonuses/Commisions 100,188. 304,199.
General + Admin Exp 1,838,005. 5,241,198.
Salaries-Corporate 771,513. 2,202,738.
Company Benefits 502,550. 1,409,047.
Depreciation Expenses 155,231. 467,564.
Gain/(Loss) Sale of Eq -19,048. -58,887.
Leasehold Expenses 11,946. 30,345.
Interest Expenses 85,420. 240,793.
Utilities 330,393. 949,598.
Tot Op Expenses 3,392,324. 9,692,296.
TOTAL -1,121,335. -3,388,253.
Is there a way to code exclusion of the Advertising line?
BethanyThis message has been edited. Last edited by: Bethany,
Server Environment: Win2K3 Server WebFOCUS 7.13 Apache Tomcat standalone application server
April 30, 2008, 11:40 AM
RSquared
Have you tried Where GL_ACCOUNT NE 'Advertising' ?
WF 7.6.11 Oracle WebSphere Windows NT-5.2 x86 32bit
April 30, 2008, 11:52 AM
Bethany
Unfortunately, I need to exclude it from one section and then include it in another.
Server Environment: Win2K3 Server WebFOCUS 7.13 Apache Tomcat standalone application server
April 30, 2008, 12:00 PM
RSquared
Where do you want to excluse it from ?
WF 7.6.11 Oracle WebSphere Windows NT-5.2 x86 32bit
April 30, 2008, 12:25 PM
Bethany
In this example, I'd want to exclude Advertising from Selling Expenses and then include it in General + Admin Expenses instead.
Server Environment: Win2K3 Server WebFOCUS 7.13 Apache Tomcat standalone application server