Trouble Finding a way to Convert Values from Half Year to Weekly Values

I am working through Level 2 Sprint 3 training and I am having trouble with creating a formula to convert data stored on a half year time scale to a weekly time scale. I would assume weekvalue('SOURCE Line Item') would be the correct function but I am not getting any values. I have changed the time summary method on the source data and still no values flow through.

Accepted answers

JussiLi

Hi @dylancolliflower,

Try to use HALFYEARVALUE function. That should work if you need to fetch data from half year time scale module to weekly time scale module.

Best regards,

JussiLi

All comments

JussiLi

Hi @dylancolliflower,

Try to use HALFYEARVALUE function. That should work if you need to fetch data from half year time scale module to weekly time scale module.

Best regards,

JussiLi

Quick Links

Can you help?

Unanswered questions

Using Anaplan for Managing Custom Product Configurations (Example: Designer Dolls)
We’ve recently started using Anaplan to model and manage our supply chain and production planning for a niche ecommerce business that sells custom-designed dolls — each made-to-order with specific features, materials, and delivery lead times. A few interesting challenges we faced: SKU Explosion: Each doll can be customized…
OData Rest API for
Hi, Does anyone know how to get an outbound OData Rest API, (OAuth2) to establish a connection between SAP and Anaplan. Thanks Khaled
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.…