help with sum of previous periods

Post Reply
Wirt
Posts: 37
Joined: Fri Feb 21, 2014 9:55 am
OLAP Product: Cognos TM1
Version: 10.1
Excel Version: 10

help with sum of previous periods

Post by Wirt »

hello,

please tell me how to calculate the the sum of previous periods?

suppose that

Jan.2014 = sum 25 months ago
Fab.2014 = sum 28 months ago
Mar.2014 = sum 26 months ago

I mean that the number of months may be different.
who knows tell me please
thank you
Alan Kirk
Site Admin
Posts: 6667
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: PA2.0.9.18 Classic NO PAW!
Excel Version: 2013 and Office 365
Location: Sydney, Australia
Contact:

Re: help with sum of previous periods

Post by Alan Kirk »

Wirt wrote: please tell me how to calculate the the sum of previous periods?

suppose that

Jan.2014 = sum 25 months ago
Fab.2014 = sum 28 months ago
Mar.2014 = sum 26 months ago

I mean that the number of months may be different.
Personally I haven't had a particularly "Fab".2014 to date, but that aside... "different", based on what? As per the Request For Assistance Guidelines, (3) Try to make the question as specific as possible. ), let's dump the (increasingly annoying[1]) hypotheticals and describe exactly what it is that you're trying to do, and by what method. How is the dimension structured? What input(s) drive the number of periods that you're after? Anything else that may be relevant?

--------------------
[1] From a number of recent threads, I know that I'm not speaking for myself alone in saying this.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
Wirt
Posts: 37
Joined: Fri Feb 21, 2014 9:55 am
OLAP Product: Cognos TM1
Version: 10.1
Excel Version: 10

Re: help with sum of previous periods

Post by Wirt »

Ok, I will try to explain in more detail
we have the following picture:

.......................Jan.14|Fab.14|Mar.14|...
Sum of prev.per...|.......| .......| .......|
Number of months.|..25..|..28...|...23..|...

(sorry for such a view, I'm the first on the site)

Number of months - calculated by the formula, and we get some value (25, 28, 23 ... )

Sum of prev.per - looks at values ​​in the cell "Number of months", and calculates the sum of months ago

for example:
Sum of prev.per(Jan.14) = sum 25 months ago
Sum of prev.per(Fab.14) = sum 28 months ago
Sum of prev.per(Mar.14) = sum 23 months ago ...
and so on

if you need more details, write, I will answer
thank you.
Post Reply