Updating time dimension to the correct dynamic formula

For this individual above, he started on December 2024 (H1 FY24) but the way I have the time settings set up it is 1 year before and 2 years after the current year and it is making this person start their proration at the beginning of the model calendar as opposed to their actual start date. I am trying to use these percentages to figure out their prorated quota but I cant quite figure out how to make it so that this individual, and others, would start the proration during the month that they have started. Below is the calculation field I have set up.

IF 'On Board and Quota Counts?'

THEN 'SYS030: Quota Proration'.Proration Factor[LOOKUP: 'SYS000: Time Settings'.'Month of Quarter (List)']

ELSE 0

Accepted answers

All comments

rob_marshall

@hyunkangs

Try using if item(time)>=start(actual start date) then …..where actual start date is the line item identifying when the person started employment.

Dikshant

@hyunkangs,

Build the active logic as below:

Trying to cover all corner cases for active logic:

Based on this active logic make you condition as:

Formula: IF Employee Forecast By Month.Active THEN 'SYS030: Quota Proration'.Proration Factor[LOOKUP: 'SYS000: Time Settings'.'Month of Quarter (List)'] ELSE 0

Let me know if you have any question.

Quick Links

Can you help?

Unanswered questions

Different Subsets of Parent Lists in Input & Output Modules
I have 2 lists used in modelling, In Input module I'm using subset of territories from Country List and subset of Regions from Flat list. But in Output module,Its reversed, I'm using subset of regions from Country list and subset of territories from flat list.How to derive the numbers from input to output module. I do have…
Is there a way to turn off the Show Comments Summary panel in UX pages with Comments?
This shows all comments across all data to all users with access to the UX page. This is not appropriate for any UX which might contain security access sensitive data. Comments on grids and cards ARE security dependent. That works fine. But anyone with access to the page can open this Summary Panel and see ALL comments…
Are there any plans to support actions to rename or delete native Versions?
If anyone is aware of idea exchange ideas that are currently being evaluated by the product team, if you don't mind linking them here, would love to give them an upvote. Thanks!