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

Accepted answers

nvaddadhi

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

Regards,

Nagendra

kavinkumar

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

All comments

DavidSmith

@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

nvaddadhi

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

Regards,

Nagendra

kavinkumar

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

Quick Links

Can you help?

Unanswered questions

Sorting General List
Hi, I wonder if there's a way I can sort my general list alphabetically. The list is used as a drop down menu in a line item module and I want the drop down menu to be easy to navigate. I've already tried the Order List action. I already have a module with a text-formatted line item based on that list. But when I try to…
Predefaulting A Feild in ANAPLAN
Hello Anaplan Community, I have a special requirement from a customer and would appreciate your input. Let me explain the situation: We have a hierarchy with three levels: Level 1, Level 2, and Level 3. Screen 1: Creation of Level 1 Items On this screen, the user selects a team. Based on their selection, an action runs to…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…