TM1 Forum

I have eList with structure like that:
-1
|-2
|-3
In Contributor report, which use this eList to create report, there are field B,C and field which is result of calculation: A=B/C.
If report created for element 2 result is A2, for element 3 result is A3, for element 1 result is A1 = A2+A3 but this result is wrong because it is not equal to B1/C1(B1=B2+B3, C1=C2+C3). All formula I create in Planning Analyst. Could you say how to resolve this problem?

Associated with each formula is a "Priority". You need to set this to high so that the calculation will be done on the aggregated numbers.

Duncan P wrote:Associated with each formula is a "Priority". You need to set this to high so that the calculation will be done on the aggregated numbers.

All cells in table 1(report from element 1) are sum of appropriate cells from table 2(report from element 2) and table 3(report from element 3). I want that cell A in table 1 was not sum from cells A of table 1 and 2, I want that cell in table 1 was result of the calculation: B1/C1

Sorry for my English.