When I am using monthvalue function it is not working Plz reply
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.
is this correct?
Hi @laxmitater , Your formula makes sense. It is rightly fetching month value to corresponding weeks