Salary calculation based on Validity of the position

Options
akprasa23
akprasa23 Member, ALL USERS, Certified Model Builder Posts: 1 New Contributor
in Planning & Modeling

Hi All,

 

i am trying to populate a Position Validity Boolean based on the months a particular position is valid based on Effective From and Effective Till Months.

eg,if a position has effective from and effective till months, the Boolean should not only tick those months else if the position has only effective from month it should tick entire timescale of the model.(as in attached image)

I would need a formula for the same.

 

Thank in advance

 

 

 

 

Tagged:

Categories