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)']