Section 12, Activity 17, 201: Intermediate Model Building

Options
debbietan
debbietan Member, ALL USERS, Partner Posts: 3 Occasional Contributor
in Anaplan Community

Josh Elwood from Northeast sub-region joined the company on 2/5/15. He turned active and headcount:1, tenure:1, ramp:0.05, ramp status: 0.05, quota: 3,125 started in February per my formulas. However, he was considered as active, and headcount:1....started from March per video lecturer.  Therefore, it had affeacted the result for Sub-region Quota Module in section 13.  

My formulas: 

Headcount formula: IF Quota>0 THEN 1 ELSE 0

Active?: 

IF ISBLANK(Rep Setup.Start Date) THEN FALSE ELSE IF Rep Setup.Start Date > END() THEN FALSE ELSE IF ISNOTBLANK(Rep Setup.End Date) AND Rep Setup.End Date < START() THEN FALSE ELSE TRUE

 

Tenure:

IF NOT Active? THEN 0 ELSE IF YEAR(START()) - YEAR(Rep Setup.Start Date) = 0 THEN MONTH(START()) - MONTH(Rep Setup.Start Date) + 1 ELSE 12 - MONTH(Rep Setup.Start Date) + (YEAR(START()) - YEAR(Rep Setup.Start Date)) * 12 - (12 - MONTH(START())) + 1

 

Hope someone could shed the light. Thank you.  -Debbie 

 

 

 

Tagged:

Comments

  • debbietan
    debbietan Member, ALL USERS, Partner Posts: 3 Occasional Contributor

    Pls disregard my question. I found the error and fixed it. 5% was edited on the Base and Period 1 on Ramping Profile Module by accident. It should be 0 instead. Thus, tt had resulted 1 for the headcount in Feb 2015. Thanks. -Debbie 

Categories