Forum Discussion

Yogesh007's avatar
Yogesh007
New Contributor
1 day ago

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

line item modeling (lim)

2 Replies

  • Yogesh007's avatar
    Yogesh007
    New Contributor
    12 hours ago

    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?

     

     

  • T_Kress's avatar
    T_Kress
    Icon for OneStream Employee rankOneStream Employee
    23 hours ago

    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.