Congratulations! You are now officially the guru. -Lou ---------------Original Message--------------- From: rpolit Sent: Monday, July 05, 2010 1:21 PM Subject: Report painter formula > Hi All, > > I have a requirement as follows: > An income statement in the Report Painter set up with 5 rows of segments going across - with totals at the end, and income statement particulars going downwards. My problem: > 1.) Despite my formula of X001 + X002 + X003 + X004 + X005 in the totals column, the figure does not appear on report generation - in fact, the column total does not appear at all. > 2.) The I/S should look like the one below: > Segment1 Segment2 Segment3 Segment4 Segment5 Total > Results per TB 11,996 1,784 4,226 13,869 -23,003 8,872 > Less Adjustments 5,136 0 6 4,440 -32,272 -22,690 > Turnover -81,547 -81,547 > WBS 1,104 1,104 > Material costs 1,372 6 1,080 45,639 48,097 > > How do I define a formula per line as above e.g WBS which will be taken into account in the totals column > > I would be extremely grateful for any help. > > Regards | __.____._ Copyright © 2010 Toolbox.com and message author. Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251 | | _.____.__ |