Hi - how far off am I this being correct?'DEM01 Volume Growth Rates'.Growth % * 12 / 52
I have resolved with this:
@lcapon
If you are cascading the growth percentages from Month to Weeks, you are way off. You don't have to multiply or divide it by anything - just pull the values from Top to bottom. You will have to use LOOKUP while doing so.
If your Jan month shows 1% growth for a Product Family then the expected result is that all 4 weeks of Jan should show 1% growth rate for that particular product family.
Thank you - please can you give me a little advance regarding the lookup required - i'm blank this morning!
No Problem. That happens to the best of us.
Here is the formula that is required to pull the values. I would recommend you understand the formula and the usage of LOOKUP in such cases. Since Anaplan doesn't know how to cascade the values from Month to Weeks, we are asking it to use Whatever values we have at Parent level ( Month Level) in Weeks.
Thank you - I'm still lost i'm getting this error.
@lcapon it might be that your module or line item has different name, did you check that? In general, try to go to the module and click on the line item instead of typing the formula, it can help you to avoid such errors.
I did this, but I wasnt sure how to select the second half of the statement?
Please see screen shots below:
Hello Community members, Requirement Details: I have 5 levels of composite hierarchy list (A1, A2, A3, A4, A5). I have published a module in UX, Now the requirement is If user select a list member from A4 level in the context selector or Custom Filter I have to display all the list members under that A4 level. How can I…
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…
