The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.
Forum Discussion
Headcount calc in LIM WF Model
Is there any way to calculate Headcount where I will use start Data and end date of Current period. If the difference is more than 1 then my HC is 1, I cannot use current period end date in Formula,
I tried IIF (DateDiff(month, start date, Current Period)>1,1,0) but it is not giving me any result
2 Replies
- T_Kress
OneStream Employee
This works out-of-the-box in LIM as follows:
If you set up an account and formula as listed above, then here is how it appears upon calculation:
I have employees with varying start and end dates. It only populates "1" for headcount for the periods that are => their start date and <= their end date. That works out of the box. If you want to do partial month headcount for mid-month starts, then that would be custom.
Thanks for the reply, it works, we have applied formula in "Formula Name" itself.
Isn't it required to set the formula in space provided?
