Hello,
I'm trying to pull weekly data into a module that is based on months. I've tried to use the WEEKVALUE formula, it returns 0. My source data has a week value assigned to it.
Thanks
Hina
HI @hinamahmood1994 ,
Why can't we directly refer the line item of Weekly module in Monthly module as Month is one level above in the time hierarchy so system will automatically sums up.
Can you please make sure that the summary of that line item is Sum (Source Module Weekly)?
Hi,
That did the trick - I had the summary as sum, time summary as 0. Changed that to sum it fixed the issue.
Thank you.
I've tried that, it returns 0.
Hi Hina
I think you should mark Kavins post as solution 😉
I am trying to set the model in Time to be only months and remove Quarters and FY. For example the course structure example is the following: Although my results include Q and FY: I already tried changing the summary and leaving none for time Time Summary, all it does is to leave it blank, but still showing.
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.…
Estimated Level of Effort:4-8 Hours of Model Building Level of Difficulty: Beginner Recommended Training: L2 Model Builder Training Persona: Casual Model Builder Potential ROI: Decreased planning time Increased accuracy of targets/spreads You Might Also Like: * Historical Snapshotting Top-Down Allocations Whether it's…
