Hi,
Module1 = dailysales has customer-product and date line items
Module2 = periodsales has customer-product and startdate and enddate lineitems
I want to SUM the sales from Module1 in Module 2 where the product matches and the date is within the start and end dates
I can SUM using the customer-product :
periodsales.salesvolume = dailysales.volume[LOOKUP:'customer-product',SUM: dailysales.'customer-product']
but obviously this gives me the total sales for the customer-product regardless of date
I need to SUM If the cusotmer product matches and the date>=startdate and date<=enddate
something like this
periodsales.salesvolume = dailysales.volume[LOOKUP:'customer-product',SUM: dailysales.'customer-product', SUM:dailysales.date >=startdate, SUM:dailysales.date<=enddate]
this does not work, is there a way to do this please?
thanks