Register

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.

3 REPLIES 3
Master Anaplanner/Community Boss

## Re: Sumif quantity between two dates without time dimension

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

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

Certified Master Anaplanner

## Re: Sumif quantity between two dates without time dimension

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.

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.