We have added search box. Key in SAP issue keyword to search
TopBottom

Announcement: wanna exchange links? contact me at sapchatroom@gmail.com.

RE:[sap-acct] Report painter formula

Posted by Admin at
Share this post:
Ma.gnolia DiggIt! Del.icio.us Yahoo Furl Technorati Reddit

Posted by Joe Kool
on Aug 19 at 12:21 PM
Mark this reply as helpfulMark as helpful
This is working as you described. Thanks you so much!

If someone can figure how to get it to total at the hierarchy points, that would awesome.

---------------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
In the Spotlight
How Do You Use Social Media to Advance Your Career? Take the Survey, Win an iPad
_.____.__

0 comments:

Post a Comment

T r a n s l a t e to your language