About Kayley

凯利 · ‎07-21-2021

Hi All, I have a list with custom month format and the list code is 'mmm-yy Code' example: 'Apr-21 VLIB0065E' (below image) However, the source file i have received is in Year-Week example '2021-01' (2021 = Year, 01- first week of 2021 which is Jan) How do i convert weeks to month?

凯利 · ‎07-12-2021

Hi Mark, Thank you for your reply. The source data has a dimension of VVD list roll up by Months. So, what i'm trying to achieve is to have look at the VVD on the row, trace to it Revenue Lane and link to the target module to identify which slottage type it is. Below is the target module i'm using VVD rolling up to Revenue Lane. I have did one manually, based on its VVD and Revenue Lane and below is the mapping i did, the co-relation between revenue lane and it slottage type

凯利 · ‎07-12-2021

Hi Everyone, I have a question on how to do a linkage between 3 modules (Source Module, Mapping and Target) The image below is my mapping, basically, each Lane is connected to each Slottage Type based on each column. eg: if a lane is AA1AO "SC In - Consortium" should appear in the line item "Chartered In Exp - Initial Slots Type" and Line Item "Chartered out income - initial slots (type)" will have "SC out - Consortium" etc. I have already created a mapping as per below image However, my goal is to let it map automatically based on the code rolling up to the lane (revenue lane) dimension. Below imagine is my source data. each code on the left are link to its lane Target Module: I'm not sure what logic to use here.

凯利 · ‎06-15-2021

Thank You so much!!

凯利 · ‎06-15-2021

Hi @LipChean_Soh Thank you for your explanation, however when i deduct the disposal it will happen the following month. meaning to say if disposal is on 31st March 2020, then final TEU in April 2020 will deduct the disposal TEUs instead of March.

凯利 · ‎06-15-2021

Hi Everyone, I need some help in building a model. So basically, from the above image, I have manage to read the Total Nominate TEUS for each month but I'm not sure How to: 1) let the system to know that, if there's a disposal in a particular month (eg. March and June) then the follow month (Apr and Jul in this example) will use the previous total nominate TEUs - the disposal nominate, 2) and in the subsequent month it will read the latest Total Nominate TEUs. I have actually created a Boolean in Anaplan, which I think might be needed in the case. (I was trying IF THEN ELSE function but I got stuck) Thank You!

凯利 · ‎05-23-2021

Hi @rob_marshall Thank you the detail explanation!

凯利 · ‎05-23-2021

Hi @AntonMineev Thank you for the detailed explanation!!

凯利 · ‎05-21-2021

大家好，我希望有人可以向我解释列表中“组织”列的目的是什么，并且由于此列被弄清楚，我想知道我们如何解开它？

凯利 · ‎12-16-2020

嗨@nathan_rudman，@nithya，@chrisaheathcote非常感谢您的解决方案！现在起作用！

凯利 · ‎12-16-2020

Hi @Nithya Thank you for your reply. Yes, i have created a separator to identify the Day, Month and Year as per image below. However, i'm not sure how to change the numeric month 4, to April and I'm not sure how to combine the day month and year together in a line item, so that it read 1 April 2020.

凯利 · ‎12-16-2020

嗨,我有一个日期格式的行项目(穰mple: 4/1/2020) - this is in mm/dd/yyyy format However, i want to show as 1 April 2020 or 1 Apr 2020. How do I do that?

About Kayley

How to convert Weeks to Month?

Re: Create a report view based on its criteria

Create a report view based on its criteria

Re: Calculation Function - Minus Disposal Month

Re: Calculation Function - Minus Disposal Month

计算功能 - 减去月份

Re: What is 'Is Organization' in List

Re: What is 'Is Organization' in List

What is 'Is Organization' in List

Re: How to change date format DD MMM YYYY

Re: How to change date format DD MMM YYYY

How to change date format DD MMM YYYY

Re: Calculation Function - Minus Disposal Month

Re: What is 'Is Organization' in List

Re: What is 'Is Organization' in List

NUX：允许在工作表中的模块视图中枢转

Re: How to change date format DD MMM YYYY