Highlighted
New Contributor

Sumif quantity between two dates without time dimension

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

3 REPLIES 3
Highlighted
Master Anaplanner/Community Boss

Re: Sumif quantity between two dates without time dimension

@nvaddadhi 

I don't have all of the details from you post, but I solved a very similar case earlier in the year.

 

If you read the following:

https://community.anaplan.com/t5/Anaplan-Discussions/Simple-Sum/m-p/39736

 

and keep reading to the bottom, you will see how I solved it

I hope that helps

David

Highlighted
New Contributor

Re: Sumif quantity between two dates without time dimension

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

 

Regards,

Nagendra

Highlighted
Master Anaplanner/Community Boss

Re: Sumif quantity between two dates without time dimension

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

 

 

Regards,
Kavin.