I need to calculate which date each week represents, I have a Weeks Attribute Module. I have tried some formulas but they did not work. I would really appreciate if someone could give me some advice or a direction.😊
seymatas1 Thank you for your response, but unfortunately I am not using weekly calendar.
I would be assuming you had created a list that had the weeks and years in it, similar to the Weeks under time dimension.
You should be able to achieve the results with the following line items:
How my custom week list looks:
Formula behind it:
You can derive a start and end date, and then point your dates back to between this range to derive your custom week.
Hope it helps in the right direction!
Best regards,
Derek
Model calendar has an option to show week start or end dates. You can utilize it if you are using weekly calendar.
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…
Why in my model output is blank, after send explainability data.
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…
