Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Reply from Joe Kool on Aug 14 at 5:04 PM Thanks for taking time to look at this and your suggestion. I will play around a little more and see if I can get it to work the way you suggested. If all else fails, then I'll just create the additional set.
Joe
| | | ---------------Original Message---------------
From: Louis Corato
Sent: Tuesday, August 14, 2012 4:55 PM
Subject: Subtract a Basic Set With Another Basic Set to Come Up With a New Set
Hi,
Joe - I understand the maintenance dilemma very well.
It sounds like you're doing an elimination with your calculation. So if Company X is in set A and in set B, you would want to subtract the amount and show zero for Company X, thereby eliminating the company from the mix of totals.
If that is the case, do you think it would work using the sets as columns instead of rows, with a third column as the calcuation? If so, then you might be able to get Company X in set A to line up with its counterpart in set B and show a zero in the third column for that pair. The individual companies would come through with the accounts in the lead column instead. You might be able to play with the layout to hide the rows that had zero in the calculation column, netting you only the rows that were exclusively in set A. I would try that and see what happened.
Otherwise, I don't know how you would be able to do anything in row 3 that isn't a total figure. I don't believe SAP would be able to "pair" the set A and set B values if they are in rows.
- Lou |
| Reply to this email to post your response. __.____._ |   _.____.__ |
