Splitting a date range into percentages per month.

GermanH

Hello all, 

I'm trying to split dates and apply a percentage completed per month based on how much of that date range lies in each month. Does anyone have an example of how they achieved something similar?

I tried my hand at a formula but its giving me a malformed function error.

alteryx screenshot.png

alteryx screenshot 2.png

AncientPandaman

the formula have error. in the min() part. it missing ")" that cause the syntax error.
and in the min(), it should be "2023-12-01" instead of "2023-11-01"

to do as dynamic month (avoid hundreds of formula), use generate row to generate month and change abit in the formula. (so 1 formula is applied to any month), and crosstab later to see the months, and you can rename if required.

however, it different from what I calculate.

[p2] is follow your formula:


here my formula

month by percentage.yxmd