Forecast Seeding - Need to Add Headcount

kmilner
New Contributor

We seed actuals into the monthly forecast, but headcount isn’t pulling over and we’d like it to for reporting. 

I found where the business rule is for this process and can see it is currently set up to just pull Income Statement accounts.  I just don’t know how to update/change it to include headcount (our headcount is a statistical account).

 

kmilner_0-1684765880250.png

 

7 REPLIES 7

NicolasArgente
Valued Contributor

Hi there!
What is the account type of your "Headcount"?
Thanks

Connect with me on:
LinkedIn: https://www.linkedin.com/in/nicolas-argente/
Website: https://aiqos.io
If you want to lift yourself up, lift up someone else.

It is a Statistical Account, with an account type "flow"

kmilner_0-1684767865053.png

kmilner_1-1684767951784.png

 

@kmilner  Just add the Haedcount account under accountfilter string -

Old

Dim accountFilter as string ="A#IncomeStatement.Base"

New

Dim accountFilter as string ="A#IncomeStatement.Base,A#Headcount"

 

That was my original thought as well, however when I test that update nothing is being kicked over from actuals.

 

Hey @kmilner!
Can you see the headcount in a cube view? After running the cube view, can you display the cube POV information? Can you show us the formula syntax and also the code you are using.

Connect with me on:
LinkedIn: https://www.linkedin.com/in/nicolas-argente/
Website: https://aiqos.io
If you want to lift yourself up, lift up someone else.

Here is what I am seeing when I look at the POV.

kmilner_0-1684978941129.png

 

Your data for headcount is at a different flow member called "F#EndBal_Input". In your business rule , you are filtering on the flow member with F#AddBack_Tot.Base.

Can you let us know if F#EndBal_Input is base of F#AddBack_Tot. If not , you may want to include F#EndBal_Input also in your business rule.