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
help with sum of previous periods
-
- 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
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?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.
--------------------
[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.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-
- 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
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.
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.