Rep Count from Start date to End date (if applicable)

Hi All,

We currently have a "Positions" module that is not time based. We show our current salaries, job titles, etc. that comes from our payroll data here. This "Positions" module also contains the Employee Start Date & the Termination Date (if applicable). I have created a line item that counts the amount of "Job Titles = Sales Reps" and need to get this into a module over a period of time.

Is there a way I can calculate the number of sales reps each month using the start date and termination date?

thanks in advance!

Accepted answers

All comments

ManjunathKN

Hi @CamdenMaggos

Yes you can, you can use Period() Function to identify which month the amount belongs to, be sure that you should put a logic basis on your start data//termination date.

then in the module that you want to bring by time use the line item of period() in source as mapping for SUM function in target module.

Thanks,
Manjunath

Quick Links

Can you help?

Unanswered questions

OData Rest API for
Hi, Does anyone know how to get an outbound OData Rest API, (OAuth2) to establish a connection between SAP and Anaplan. Thanks Khaled
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
CERTIFICATION BADGES - ANNOUNCEMENT
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385