05-22-2023 10:33 AM
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).
05-22-2023 11:00 AM
Hi there!
What is the account type of your "Headcount"?
Thanks
05-22-2023 11:04 AM - edited 05-22-2023 11:05 AM
It is a Statistical Account, with an account type "flow"
05-23-2023 04:26 AM
@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"
05-23-2023 03:36 PM
That was my original thought as well, however when I test that update nothing is being kicked over from actuals.
05-24-2023 03:22 AM
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.
05-24-2023 09:42 PM
Here is what I am seeing when I look at the POV.
05-25-2023 05:27 AM
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.