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

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

[sap-acct] Formula in report painter

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

Posted by Tidimo
on Mar 8 at 11:56 AM
Hi expert,
I have a question regarding report painter. i have created a report that works fine. now i have to add a formula, the requirement is the following

Report created:
Columns
total plan Plan perio 1 - Plan Perio 2......Plan Perio N
Row

A-Total revenue x no value no value no value
B-Total cost y yes yes yes

C- New row: Z
Formula { [ [ A* (-1) ] + B ] : B ] }* 100
and this is ok for me i have created it, but what i need is use this value Z to multiply it with plan period columns 1-2..n.

But my problem is that Z is a correct value only for first column. how can i use a value formula that is only in the first column to multiply for the other columns.
Thanks
__.____._
Copyright © 2011 Toolbox.com and message author.

Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
View this online
  
Tidimo
SAP Accounting Enthusiast

Contributed 100 posts in a group to earn a Bronze Achievement
Most Popular White Papers

In the Spotlight
Overcome the Top Inhibitors to Cloud Computing. View the IBM Cloud Briefing, Available on Demand.
_.____.__

0 comments:

Post a Comment

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