Forecast Seeding - Need to Add Headcount

[kmilner]

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

[NicolasArgente]

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

[kmilner]

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

[OS_Pizza]

@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"

[kmilner]

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

[NicolasArgente]

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.

[kmilner]

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

[OS_Pizza]

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.