L2 sprint 2.3.8.4 Create DEM02 Volume Growth Rates by Week module

Screenshot 2022-07-16 at 2.55.29 PM.png

Screenshot 2022-07-16 at 2.55.50 PM.png

 When I am using monthvalue function it is not working Plz reply 

 

Tagged:

Comments

  • Hi @Vibhas 

    If you look closely at the error message, it says circular reference.

    This means while applying the MONTHVALUE to growth% line item, you are referencing that same line item only.

    Right now your formula says, A = Monthvalue(A)

    It should be that A = Monthvalue(B), there must be a module where growth% by month is present, just take the month value of that line item in this module.

    Thanks,

    Rishabh.

     

  • is this correct?

    Please advice.

  • Hi @laxmitater , Your formula makes sense. It is rightly fetching month value to corresponding weeks