
1. Re: Extrapolate to Full Year
Zhouyi Zhang Jul 21, 2018 5:41 AM (in response to Tarik Cagritekin)Hi, Tarik
Can you provide a sample workbook?
ZZ

2. Re: Extrapolate to Full Year
Tarik Cagritekin Jul 21, 2018 12:11 PM (in response to Zhouyi Zhang)Hi Zhouyi,
Thanks for your reply first of all. I've attached a testfile..
Hope you can help me on this.
Regards,
Tarik

3. Re: Extrapolate to Full Year
Tarik Cagritekin Jul 25, 2018 2:48 AM (in response to Tarik Cagritekin)Hi? Is there someone who can guide me on this?

4. Re: Extrapolate to Full Year
Simon Runc Jul 25, 2018 2:57 AM (in response to Tarik Cagritekin)Hi Tarik,
Will this formula do what you need?
(RUNNING_SUM(COUNT([Source]))/MAX([Number Of Fte Working On S2C]))
/MIN([Date (Months)])*12
Let me know if that's not what you were after (and why it's wrong) and I'll take another look

5. Re: Extrapolate to Full Year
David Maning Jul 25, 2018 3:50 AM (in response to Tarik Cagritekin)1 of 1 people found this helpfulHi,
Here is your answer:
RUNNING_SUM(COUNT([Source]))/ MAX([Number Of Fte Working On S2C]) / ATTR(MONTH([Date])) *12
Trust this helps.
D

6. Re: Extrapolate to Full Year
Tarik Cagritekin Jul 25, 2018 4:59 AM (in response to Simon Runc)Hi Simon,
Thanks for your help. Unfortunately it is not working. I tried to see if the formula is giving the result, which will at the end do the math. So MIN([Date (Months)])*12 is giving the expected numbers. but combining it with the rest of the formula is giving total different numbers. I tried to see if there is a logic in there, but couldnt figure out.

7. Re: Extrapolate to Full Year
Simon Runc Jul 25, 2018 5:03 AM (in response to Tarik Cagritekin)hi Tarik,
...but combining it with the rest of the formula is giving total different numbers
what is the "rest of the formula"?

8. Re: Extrapolate to Full Year
Tarik Cagritekin Jul 25, 2018 5:19 AM (in response to Simon Runc)Hi simon, Sorry for being unclear; I meant RUNNING_SUM(COUNT([Source]))/ MAX([Number Of Fte Working On S2C]) this part.


10. Re: Extrapolate to Full Year
Simon Runc Jul 25, 2018 5:26 AM (in response to Tarik Cagritekin)So in your original question you showed this
result of month 1 (which is 1,33) / 1 * 12
result of month 2 (which is 2,33) / 2 * 12
result of month 3 (which is 4,25) / 3 * 12
Where the formula
RUNNING_SUM(COUNT([Source]))/ MAX([Number Of Fte Working On S2C])
For January, say, returns 1,33...
With the additions of the
/MIN([Date (Months)])*12
This seems, to me, to be calculating correctly (from what you've asked)
Returning 1.333333/1*12 = 16
What would you want the calculation to return for January? and then February

11. Re: Extrapolate to Full Year
Simon Runc Jul 25, 2018 5:29 AM (in response to Tarik Cagritekin)Ah it's the fact we're getting 16, not 15.96. That's just because your display level for the value is 2 d.p. but the actual value is 1.3333333333
If you try this formula, which enforces the rounding to 2 d.p. that will get you to 15.96
ROUND((RUNNING_SUM(COUNT([Source]))/MAX([Number Of Fte Working On S2C])),2)
/MIN([Date (Months)])*12

12. Re: Extrapolate to Full Year
Tarik Cagritekin Jul 25, 2018 5:39 AM (in response to Tarik Cagritekin)Hi David,
I think the formula is correct. They weird thing is dat in my formula RUNNING_SUM(COUNT([Source]))/ MAX([Number Of Fte Working On S2C]) the zeroes were excluded somehow. So the figures I was expecting were nog correct.
Thank you both on your time and effort.. Much appreciated.