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

akashagarwal
akashagarwal
in Modeling

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

image.png

Target Module: CAL01 Start & End Month

image.png



Tagged:

Best Answer

  • Prajjwal88
    Prajjwal88
    Answer ✓

    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:

    image.png

    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.

    image.png

    I hope this helps.

Answers

Categories