How to display date as Week number?

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.

clipboard_image_0.png

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

Tagged:

Best Answer

  • kavinkumar
    Answer ✓

    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.

Answers

  • Additional:

     

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

     

    clipboard_image_0.png

  • 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.

  • Hi Kavin,

     

    Thanks for your advice.

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

     

    Regards,

    Inoue

  • Hi Kavin,

     

    This is solved.

    I appreciate for your kind suppport!

     

    Regards,

    Inoue