Weighted average in the sum of the year

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

Weighted average in the sum of the year

Post by Wirt »

hello everyone

I have a question about Weighted average in the sum of the year.
example:
I have an element that displayed in %, element = 5% for each month, so the total for the year = 60%, but I need in the total for the year 5%,
it is necessary that the amount for the year divided by the number of months, and we get a 5%,

maybe someone knows the algorithm for calculating
I'll be very grateful for the help
BariAbdul
Regular Participant
Posts: 424
Joined: Sat Mar 10, 2012 1:03 pm
OLAP Product: IBM TM1, Planning Analytics, P
Version: PAW 2.0.8
Excel Version: 2019

Re: Weighted average in the sum of the year

Post by BariAbdul »

"You Never Fail Until You Stop Trying......"
Wirt
Posts: 37
Joined: Fri Feb 21, 2014 9:55 am
OLAP Product: Cognos TM1
Version: 10.1
Excel Version: 10

Re: Weighted average in the sum of the year

Post by Wirt »

thank, you very much helped
Post Reply