About Kayley

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?

Kayley · ‎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

Kayley · ‎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.

Kayley · ‎06-15-2021

Thank You so much!!

Kayley · ‎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.

Kayley · ‎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!

Kayley · ‎05-23-2021

Hi @rob_marshall Thank you the detail explanation!

Kayley · ‎05-23-2021

Hi @AntonMineev Thank you for the detailed explanation!!

Kayley · ‎05-21-2021

Hi Everyone, I was hoping someone could explain to me what is the purpose of 'Is Organization' column found in the List and since this column is greyed out I would like to know how we can untick it?

Kayley · ‎12-16-2020

Hi @nathan_rudman , @Nithya , @ChrisAHeathcote Thank you so much all for your solutions! It works now! 😁

Kayley · ‎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.

Kayley · ‎12-16-2020

Hi, I have a date formatted line item (example: 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

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: Allow pivoting in module views in a worksheet

Re: How to change date format DD MMM YYYY