Formulas - dimensions month vs years & collect

Hi,

I have a module that shows line items in years and uses the collect() function.

I now need this in months, so have made a copy of this module, changed dimensions to months and there's currently no figures showing. How do I fix this?

Thanks in advance

Accepted answers

All comments

ChrisAHeathcote

@CommunityMember113484

Use YEARVALUE() function to pull the data from the module using COLLECT().

This will allocate the year value to each corresponding month.

However, it will not phase the year value across months in the year as it will simply assign the year value to each month.

To do this you need to decide how you wish to phase the year value down.

CommunityMember113484

Thanks Chris. I think I'm still struggling with the collect() function.
In the original module (year), the formula states IF X THEN if Y then Collect() ELSE 0. When I drill down to this, it takes me to a new module where the figures are being collected from.

In the new monthly module, the formula is still the same, but when I drill down, it doesn't take me to that original module? I'm left with just 0?

ChrisAHeathcote

@CommunityMember113484

The monthly module should simply reference the module holding the yearly data.

No IF THEN ELSE just YEARVALUE()

alexpavel

@CommunityMember113484 My impression is that the current original data from the current original module (the module before the COLLECT() ... they are already at Year level.

If this is the case, then, this is the issue: Target module is at month level and Source module is at Year level.

I think you should trace back in your model what is the module where data are at the month level.

Hope it helps

Alex

Quick Links

Can you help?

Unanswered questions

import monthly data with months in columns
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,
Cloudworks Big Query Integration Fail
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…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…