Skip to main content
Y
Yogesh007
Newcomer
June 7, 2026
Question

Headcount calc in LIM WF Model

  • June 7, 2026
  • 2 replies
  • 0 views

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
T_KressOneStream Employee
OneStream Employee
June 7, 2026

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.

Y
Yogesh007Author
Newcomer
June 8, 2026

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?

 

 

Terms & ConditionsAccessibility statement