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
Weighted average in the sum of the year
-
- 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
This might help you:
http://www.tm1forum.com/viewtopic.php?p=11292
http://www.tm1forum.com/viewtopic.php?p=11292
"You Never Fail Until You Stop Trying......"