When I am using monthvalue function it is not working Plz reply
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
Check out the latest Anaplan feature updates and enhancements in our September 2026 official release notes. There you'll find information on: User Experience KPI cards Mobile Zoom and pan KPI Conditional formatting Intelligence CoModeler Analyst Optimizer Disclosure Management Refreshed user interface Anaplan Data…
Please take note of the following changes in our latest 2608 release: Multi-dimensional calculations now require valid rules. As of 2608, the multi-dimensional calculation process no longer runs when invalid rules are present - for example, a rule referencing an invalid member (one that no longer exists in the dimension).…
