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?
Formula in Contributor report
-
- MVP
- Posts: 600
- Joined: Wed Aug 17, 2011 1:19 pm
- OLAP Product: TM1
- Version: 9.5.2 10.1 10.2
- Excel Version: 2003 2007
- Location: York, UK
Re: Formula in Contributor report
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.
-
- Posts: 6
- Joined: Wed Oct 19, 2011 8:14 am
- OLAP Product: Cognos
- Version: 8.4
- Excel Version: all
Re: Formula in Contributor report
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/C1Duncan 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.
Sorry for my English.