topic Re: Dividing a total value over 12 months in App Development

Dividing a total value over 12 months

Jaden — Thu, 19 Jun 2025 14:47:51 GMT

Hi all,

I have a question that revolves around creating months and attaching a value to them.

What I have:
- Start Date
- End Date (12 months in the future)
- Estimated Volume
What I need:
- To create the 12 months between these two dates and add (Estimated Volume / 12) to these records.

For example:

Start Date	End Date	Estimated Volume
1/1/2025	12/1/2025	120

Taking the above and turning it into this:

Any advice would be appreciated. Thank you.

marcus_sommer — Thu, 19 Jun 2025 15:27:13 GMT

Maybe something like this:

t: load
date(addmonths(StartDate, iterno() -1), 'MMM-YY') as MonthYear,
Volume / 12 as Volume
from Source while iterno() <= 12;

Jaden — Thu, 19 Jun 2025 18:44:51 GMT

After much research, I found a solution to this issue using Crosstables. See here: