Hello
Depending on period in month, I'd like the data in Data to be uplifted by doing the following = data value * (1+ (a portion of Adjustment Assumption for the month and country in question))
If data's date is within the first 10 days of the month, apply 1 + (80% of Adjustment Assumption for month and country in question)
If data's data is outside of the first 10 days of the month, apply 1 + (20% of Adjustment Assumption for month and country in question)
So instead of applying a flat rate assumption for the whole month, I want to split it in two lots, one view for 1st 10 days of the month and another view for remainder of the month. Because the behaviour is different throughout the month, so a flat rate adjustment wouldn't make sense.
For example = Germany for October is showing 4% Adjustment Assumption. If date is within first 10 days of October, than data for that date should be increased by multiplying the data * (1+ (80% of 4%)). If date is outside of the first 10 days of October, data * (1+(20% of 4%))
Want the final result to be shown in the first tab, Adjusted Data
hope that kind of makes sense!
Bookmarks