Level 2 - 2.3.8.4 Activity

drathod
Occasional Contributor

Level 2 - 2.3.8.4 Activity

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.

 

drathod_0-1625589641974.png

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
anand.shekhawat
Super Contributor

Re: Level 2 - 2.3.8.4 Activity

@drathod 

The formula used in the module is absolutely correct. You are converting a monthly % value into a weekly % value that you would be using in the further weekly dimensioned modules. So you can understand this in the below way

 

The below is the Weekly Planned Data

anandshekhawat_1-1625604693083.png

 

 

The below is the same data but planned monthly

anandshekhawat_2-1625604765858.png

So the incentive percentage in the First table is the MONTHVALUE of the incentive Percentage of the second table

 

I hope you understand the logic

 

~Anand

 

 

View solution in original post

2 REPLIES 2
anand.shekhawat
Super Contributor

Re: Level 2 - 2.3.8.4 Activity

@drathod 

The formula used in the module is absolutely correct. You are converting a monthly % value into a weekly % value that you would be using in the further weekly dimensioned modules. So you can understand this in the below way

 

The below is the Weekly Planned Data

anandshekhawat_1-1625604693083.png

 

 

The below is the same data but planned monthly

anandshekhawat_2-1625604765858.png

So the incentive percentage in the First table is the MONTHVALUE of the incentive Percentage of the second table

 

I hope you understand the logic

 

~Anand

 

 

View solution in original post

drathod
Occasional Contributor

Re: Level 2 - 2.3.8.4 Activity

that is the perfect explanation. thank you so much!