I used the following formula to return the monthly value to weeks; MONTHVALUE('DEM01 Volume Growth Rates'.Growth %). I would have assumed that the monthly figure would be divided by 4 for each of the weeks. However, it is reflecting the same monthly value across all of the weeks.
Maybe i'm missing the intuition behind this. I know that the monthvalue is the correct formula to use, but not sure why it isn't returning the value I was hoping for.
