You’re offline. This is a read only version of the page.
35
Hi All,
I am trying to implement a report which would point to any discrepancy in the inter-company accounts. The innitial report which just reports out these numbers has been build in a 2-D array structure (200,280,300 are comapny numbers). Is there any way i can show the calculations to show the difference b/w the accounts? In the sample below, Company 300 owes Comapnt 200 $ 1107.36 and its showing up in cell (1,3) and (3,1). I need to make a report which does these calcualtions, and reports out differences. I am having issues doing the calcualtions, is there a way where it can be done in MR ?
| SUB | 200 | 280 | 300 |
| 200 | -1,733,048.11 | 1,107.36 | |
| 280 | 1,729,185.90 | 106,947.00 | |
| 300 | -1,107.36 | -106,947.00 |
Report i have - 2D array showing the transactions
| SUB | 200 | 280 | 300 |
| 200 | 0.00 | (3,862.21) | 0.00 |
| 280 | (3,862.21) | 0.00 | 0.00 |
| 300 | 0.00 | 0.00 |
0.00 |
Report i need to build, showing the difference.
Please let me know if there are any questions. Thanks.
*This post is locked for comments
I have the same question (0)When you're doing a grid calculation across columns you just have to reference the column and the row.
COLUMNS A B C
ROW 30 a.60+b.30
ROW 60 c.60+b.90
ROW 90 c.30+a.90
All other cell calculations are redundant, so you can fill them in.
If you want the report to be clean, then use NP restrictions on your source cells.
If you want the data for comparison don't.
Share
Report
All responses (
Answers (
