Formula in Contributor report

Post Reply
Bladeless
Posts: 6
Joined: Wed Oct 19, 2011 8:14 am
OLAP Product: Cognos
Version: 8.4
Excel Version: all

Formula in Contributor report

Post by Bladeless »

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?
Duncan P
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

Post by Duncan P »

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.
Bladeless
Posts: 6
Joined: Wed Oct 19, 2011 8:14 am
OLAP Product: Cognos
Version: 8.4
Excel Version: all

Re: Formula in Contributor report

Post by Bladeless »

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.
Post Reply