Management Reporter - Grid Calculations

(0) Share

Report

Posted on by Dfangs

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

All responses (1)

Answers (0)

Suggested answer

Redbeard 12,931 on at

Like (0)

Report

RE: Management Reporter - Grid Calculations

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.