Your other option is to turn on Office Integration. If you view the report in
Excel the likelihood is that the missing column will?be displayed.
?
Allan Godfrey
>A.P. Godfrey Consulting Inc.
>http://www.linkedin.com/in/allangodfrey
>P?Please consider the environment before printing this e-mail and any documents
________________________________
From: Nikki Klein via sap-acct <sap-acct@Groups.ITtoolbox.com>
To: a_godfrey email@removed
Sent: Tue, July 6, 2010 3:03:37 PM
Subject: RE:[sap-acct] Report painter formula
Posted by Nikki Klein
on Jul 6 at 3:00 PM Mark as helpful
Hi Ronald
Regarding your first question: what is the width you have assigned to each of
the columns, and what is the total report width defined in the report layout? It
is not uncommon for the results screen to be wider than permitted by the report
layout definition, and in this case Report Painter creates a second screen that
contains the "missing" columns.
Nikki
---------------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
| |  a_godfrey
SAP Accounting Helper
Posted helpful replies on 5 threads in a group to earn a Bronze Achievement _.____.__ |
Mark as helpful
