nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

transform data's timescale

if Module A is in weekly time scale, Module B is in yearly time scale. What formula should I use to pull a line item from Module B to module A?

Thank you.

Tags

Importing and Exporting Data

Modeling

Calculation Functions

Data Integration

Accepted answers

Use simple time function if you are using Anaplan Time scale.

YEARVALUE()

Hope it helps!

All comments

Use simple time function if you are using Anaplan Time scale.

YEARVALUE()

Hope it helps!

Quick Links

Can you help?

Unanswered questions

Connection Problem with Excel Add-In Series 4 - No Customer
Hello everyone, I hope you're doing well. I'm posting because two of my coworkers are trying to use the Anaplan Excel Add-In Series 4, but they're running into an issue during the connection setup process. When they go to New → New Read-Only Connection (or New Connection) and reach the "Select a Customer" step, no…
explainability results is blank into model
Why in my model output is blank, after send explainability data.
How can I use the RANK function with composite hierarchies where parent items can't be concatenated?
I am working on a use case where I need to display the top 5 lines of a module as individual lines, while grouping all remaining lines under an "Others" category. The module is dimensioned by multiple composite hierarchy lists, along with Time and Version. To achieve this, I need to use the RANK function with the Ranking…