How to display date as Week number?

Tsuyoshi_Inoue1

Hi experts,

Could someone give me an advise for showing date as active week code?

In my model, standard week is converted to active week and requested shipping date.

Then, my client argues that we should export Demand forecast data in active week style (e.g. 202023 ).

This is what is exported.

無題.png

Is there any solution for this? How to use CODE function for list item?

Regards,

Inoue

Accepted answers

kavinkumar

I hope you are trying to do the export and you are expecting the code to be displayed in your export file. Hence this option will be available during your export. Else if you want the code in your module, then create a line item (Text formatted) and put a formula 'CODE(List formatted line item)'.

Hope this clarifies!!

Kavin.

All comments

Tsuyoshi_Inoue1

Additional:

In the module subset 010ActiveWeek is used as an axis. What we want to show is Code.

kavinkumar

HI @Tsuyoshi_Inoue1,

If you want to export the code instead the name of a list that is used in a line item, please make use of the 'line items of Data-Type List' tab in the export action. It defaults to Name, you can modify that to code.

How to display date as Week number..PNG

I hope this helps!

Regards,
Kavin.

Tsuyoshi_Inoue1

Hi Kavin,

Thanks for your advice.

I cant find the "Line Items of Data-Type "List"", where can I find them?

Regards,

Inoue

kavinkumar

Hope this clarifies!!

Kavin.

Tsuyoshi_Inoue1

Hi Kavin,

This is solved.

I appreciate for your kind suppport!

Regards,

Inoue

Quick Links

Can you help?

Unanswered questions

Request for Workflow Design: End-User Report Finalization & Stakeholder Notification with Version Co
Hi everyone, I'm looking to design a workflow and would appreciate your input or guidance on how to set this up effectively in Anaplan. So, the goal is: Once end users complete their data input, they should be able to trigger a process that: Notifies stakeholders via email with a link to a report. The report includes: A…
OAUTH 2.0 vs Google Sheets Extension
Hi, My org is looking to explore leveraging Google Apps script to extract data out of Anaplan and update already built templates in Google Sheets. We use the Anaplan Extension currently but find it crashes often with the amount of tabs, data, etc. Has anyone used both Anaplan OAUTH 2.0 API and Goolge Apps Script to write…
Exports with anaplan using informatica connector
I'm trying to execute an Action to export data with the use of a Mapping in Informatica. But it gives us null rows .If we export directly from Anaplan , the export file has all the rows filled. Both exports have same number of rows but in the informatica export the values appear as blank. This issue is with only some…