A bit of weird case for which I cant find any config level solution.
KF1 is disaggregated based on KF2, both structurally and along time.
KF2 has value= 0 (not blank) across Jan14 to Dec14.
I enter a value in KF1 in TB = months e.g. Jan14 = 500, Feb14 = 600, March14 = 900
I view the values of KF2 in TB weeks and this is how it looks on data view = weeksW.06.01.2014 100 W.13.01.2014 100 W.20.01.2014 100 W.27.01.2014 220 W.03.02.2014 120 W.10.02.2014 120 W.17.02.2014 120 W.24.02.2014 300 W.03.03.2014 180 W.10.03.2014 180
In the weeks split across consecutive months, I note that the values are sum of values of weeks on the either side
It is obvious to see what is happening but why will this happen and how to get rid of this obvious bad math.
PS: Storage bucket profile is weeks and months.