Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
If "A" is truly one row and "B" is also just one row, you can calculate individual cell values as row "C", one for each column. If you treat "C" as a single entity, you won't get the variability needed per column. If you calculate a cell (like you would in Excel) then you can create each value according to the column it sits in.
If there are multiple rows for each "A" and "B", then it's much more difficult to do this in Painter. You might have to resort to Writer, which would give you more flexibility based on sets.
- Lou
| | | ---------------Original Message---------------
From: Tidimo
Sent: Tuesday, March 08, 2011 11:57 AM
Subject: Formula in report painter
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
| |  LCC352
SAP Accounting Helper
Posted helpful replies on 5 threads in a group to earn a Bronze Achievement Most Popular White Papers
In the Spotlight  _.____.__ |
