Forum Discussion
Distribution calculation
I want to calculate a measure which: 40% Distribution (First 30 Days): The first portion (40%) of the value for the current month should be distributed over 30 days, but only the days rem...
Thank you for the walkthrough. I am working on the measure. Just for confirmation - if today were September 30, would you still want to distribute nearly the entire Sum of Val for September to october and november?
If today was Sep 30,
1) 40% of 1556=622.4
Days left in Sep = 1 day
Value for Sept = (622.4/30)* 1 day = 20.74
2)Carryover for Oct from Sep 40% = (Oct 1- Oct 29)= (622.4/30)*29 days= 601.65
3) 60% of 1556 will be distributed from Oct 30 onwards to Nov 28.