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.
Go to Solution.
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:
and keep reading to the bottom, you will see how I solved it
I hope that helps
Thanks David, I will check and let you know if i have any questions.
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.
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.