Allocating Measure Proportionally

[tnayfeh]

I have a time dimension with Year-Period-Week as levels. I have 2 data sources, one for BUDGET data the other with FORECAST data. The forecast data is down to the week level but the budget data is only up to the Period level. I want to allocate the budget number to divide each value by 4 to get the budget by week. Weekly Budget = Period Budget / 4.


How can I do this? If I allocate as constant it display the number for the period for each week. I get an error if I try to use a calcualted measure of Period Budget / 4.
Any ideas?

Thanks!