This can done with script. The one issue I have is that for the first partial month you use a
[Per Count] value of
0.95 when I would calculate it as
27/31 = 0.87 since the start date if four days after the start of the month.
In any event, the following demo creates a set of child records equally spaced in time (days, weeks, months, quarters, years) based on a button click and user inputs. It can easily be modified to initialize the fields you describe.
The explanation in the forum might be a bit difficult to understand as it used some technical terms from functional programming but I was just trying to demonstrate how the task of creating and initializing child records can be automated and implemented in a very general fashion. You may have to study the example a little and create your own records but the example is general enough to give you the behavior you need.
Hylo[morphism] Techniquehttps://haversineconsulting.quickbase.com/db/bkw2ff3c8Pastie Databasehttps://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=511
