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.
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
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?
Thank you so much0