Sumif quantity between two dates without time dimension

nvaddadhi
nvaddadhi
in Modeling

Here is my problem, I have two different modules without timescale or dimension. 

One module has quantity and dates. Second module has start date and end date and I would like to sumif within the range of the start and end dates. Please guide me if there is a way to solve this.

 

Sumif between two date ranges without time dimension.jpg

Tagged:

Best Answers

  • nvaddadhi
    nvaddadhi
    Answer ✓

    Thanks David, I will check and let you know if i have any questions.

     

    Regards,

    Nagendra

  • kavinkumar
    kavinkumar
    Answer ✓

    Hi @nvaddadhi ,

     

    You can achieve the same by following steps.

     

    Step 1: Bring in the Start date and End date info in your module 1.

    Step 2: Then write a condition based on your requirement in QTY SUM line item

    Step 3: Now refer the newly created line item(QTY SUM) in your Mod 2.

     

    Have a look at the below screen shot for reference.

     

    Sumif quantity between two dates without time dimension.PNG

     

    Sumif quantity between two dates without time dimension 1.PNG

     

    Sumif quantity between two dates without time dimension 2.PNG

    Note: Here I have used the 2 lists. PROD Import flat list in Mod 1 and Prod list in Mod 2. The relation between these 2 list being captured in the back end of List 1(One of the property to get Prod).

     

    Hope this solves your concern.

     

    Regards,

    Kavin

     

     

Answers

Categories