How to apply sum function(or any) on time line item?

Cee-Cee shop module is where my Spool & Cages incoming, Outgoing happens

In Cee-Cee shop module i have Expected Cee-Cee return date which is nothing but (Date + Lead time days)

Now in Expected Repair item return module, I have expected line item - What I'm trying to do is or requirement is to take from the incoming(Cee-Cee Shop module) line item to Expected(Expected Repair item return module) line item on the basis of Expected Cee-Cee return date line item(Cee-Cee Shop module)

End result will be on 1st Oct 19 when I enter incoming as 100 in Cee-Cee Shop module since the lead time is 15 days the incoming no-goes onto Expected line item but shows only on 16'th Oct 19.

I've also attached an Excel file to get a better understanding.

Thanks & Regards

Sorry if there are any language mistakes.

Cee shop daily.PNG Cee shop month.PNG

Cee shop solution.PNG

Accepted answers

LipChean_Soh

Hi,

You can use the POST formula as shown below.

Note that you can enter different lead time, and the POST keyword will accumulate accordingly onto the same day.

The 'Incoming' date calculated in 'Cee Cee From' isn't used in POST, i just put it there for reference purpose.

Screen Shot 2019-10-11 at 9.16.47 AM.png

Thanks,

LipChean

All comments

LipChean_Soh

Hi,

You can use the POST formula as shown below.

Note that you can enter different lead time, and the POST keyword will accumulate accordingly onto the same day.

The 'Incoming' date calculated in 'Cee Cee From' isn't used in POST, i just put it there for reference purpose.

Screen Shot 2019-10-11 at 9.16.47 AM.png

Thanks,

LipChean

Misbah

@vsbwofficial

Assuming you are going with two module approach where your second module ( Expected Repair item return module) has Month in a dimension and Cee Cee Shop Module has Day as a dimension. Do following steps

Go to Expected Cee Return Date Line Item in Cee Cee Shop Module and change the Summary to "Last Non Blank" for Time Period

Then Go to the Second Module and Just refer the Expected Return date & Incoming from First Module as Anaplan will automatically roll up the numbers from Days to Months. No SUM is required.

Hope that helps

Thanks,

Misbah

LipChean_Soh

Hi @Misbah

I'm curious, can you show how you "refer the Expected Return date & Incoming from First Module as Anaplan will automatically roll up the numbers from Days to Months"

And what if there are multiple values to be aggregated to the same month?

Thanks,

LipChean

vsbwofficial

Thank you so much

Quick Links

Can you help?

Unanswered questions

import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…