12 Replies Latest reply on Jul 25, 2018 5:39 AM by Tarik Cagritekin

Extrapolate to Full Year

Hi All,

I've a created a calculated field as follow; RUNNING_SUM(COUNT([Documents]))/MAX([FTE]);

giving me say de following;

Now I want do get the following;

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

and so on.

Can someone help me on this ?

Regards,

Terki

• 1. Re: Extrapolate to Full Year

Hi, Tarik

Can you provide a sample workbook?

ZZ

• 2. Re: Extrapolate to Full Year

Hi Zhouyi,

Hope you can help me on this.

Regards,

Tarik

• 3. Re: Extrapolate to Full Year

Hi? Is there someone who can guide me on this?

• 4. Re: Extrapolate to Full Year

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

Hi,

RUNNING_SUM(COUNT([Source]))/ MAX([Number Of Fte Working On S2C]) / ATTR(MONTH([Date])) *12

Trust this helps.

D

1 of 1 people found this helpful
• 6. Re: Extrapolate to Full Year

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

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

Hi simon, Sorry for being unclear; I meant RUNNING_SUM(COUNT([Source]))/ MAX([Number Of Fte Working On S2C]) this part.

• 9. Re: Extrapolate to Full Year

HI David,

I getting the idea I'm missing something here.. also Simon suggested a similar formula.

I should get 15,96 in Jan

13,98 in Feb

17 in Mar

14,25 in Apr

22,2 in May

and 28,5 in June.

Thanks both for helping on this so far.

• 10. Re: Extrapolate to Full Year

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...

/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

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

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.