Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Reply from Joe Kool on Aug 14 at 3:12 PM Thanks Lou. I do understand what you are saying, so let me try to explain with a little more detail and/or reasoning. I appreciate your patience.
Set A includes all Partner Accounts that are included in the 'Fee and Misc Income' line of our Income Statement (note: Set A is used in many other reports that are variations of the Income Statement and is defined with a range). Set B is a new set that only uses some of the partner accounts from Set A. I'm creating a new report and the requirements are to have a row that can be expanded to the partner account level. Also, this row needs to use the partner accounts in Set A and exclude all the partner accounts in Set B. Set B will also be the definition of another row below that will also need to be expanded to the partner account level. The reason I am focused on using Set A and Set B to define this row is for maitenance purposes. If I create a new set (Set C) that only contains the partner accounts I need, I will still need to have Set B created as it will be it's own row. Also, I'm now maintaining Set A for all the other reports, Set B and Set C for the new report versus only Set A and Set B. The risk is that we will miss the dual maintenace and our numbers will be inconsistent. We have many reports and many sets and the less maintenance the better.
Or, can I define a report painter row with a Partner Account(SACCT) set and also exlcude single partner accounts (SACCT) within the same row that may be included in the set?
I know I'm probably making this more difficult than it needs to be, but I know this can be done using our SAP BW query designer tool. Unfortunately, the user group does not like the BW tool.
Does this help at all?
Thanks again, Joe
| | | ---------------Original Message---------------
From: Louis Corato
Sent: Tuesday, August 14, 2012 12:45 PM
Subject: Subtract a Basic Set With Another Basic Set to Come Up With a New Set
I'm not sure what you're trying to accomplish. Let me see if an example will help.
Let's say set A is partners in the north and set B is partners in the south. Let's say that sales is the subject of the actual calculation, so that becomes a column. So row 1 has set A, row 2 has set B and row 3 is the difference between sales in set A and set B. Is that correct? If so, how would SAP know how you want to do the calculation other than to do it in total?
What am I missing?
- Lou |
| Reply to this email to post your response. __.____._ | In the Spotlight Become a blogger at Toolbox.com and share your expertise with the community. Start today.   _.____.__ |
