L2 sprint 2.3.8.4 Create DEM02 Volume Growth Rates by Week module

Vibhas
New Contributor

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 

 

1 REPLY 1
rishabh01
Frequent Contributor

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.