How to calculate project end month & project start month based on data.

akashagarwal

Hi, I am trying to calculate last month & start month basis on DAT01 TestData.

For E.g.:

For list Item A:
Start Month should be Nov 24 & end month as last data value.

Source Module:DAT01 TestData

Target Module: CAL01 Start & End Month

Prajjwal88

Hi @akashagarwal ,

To achieve the required output, since you need to transfer results from a time-dimensioned module to a non-time-dimensioned module, you will need to aggregate the data using a time function like TIMESUM(). For this, you can create another line item in the source module (where the data is time-dimensioned, such as "Start Date") and use a formula like the one shown below:

And In the target module, you can use the TIMESUM() function to aggregate these dates by applying "First Non-Blank" or "Last Non-Blank" logic. Define the start and end periods in a system lookup module, where you can use the PERIOD() function to achieve your desired output.

I hope this helps.