0

Select data based on a date range and Item number

I am new to Klipfolio and need some help selecting data into a Klip column. From the below screenshot, I need to be able to select the total amount of receipts (Column L:L) entered per item ID (Column H:H) that occured in the date range between TODAY()-10 and TODAY()-4 (Column C:C). This is what has been developed thus far:

LOOKUP(@Sheet1,G:G;,   --This is a lookup column in the Data Source 'O&M Weekly Allocation Rpt'
group(select(@sheet1,A:A;,BETWEEN(DATE(@C:C;,"MM/dd/yyyy"),DATE_ADD(TODAY()-10),TODAY()-4))),
GROUPBY(select(@sheet1,H:H;,BETWEEN(DATE(@sheet1,C:C;,"MM/dd/yyyy"),DATE_ADD(TODAY()-10),TODAY()-4))),
SELECT(@sheet1,L:L;,BETWEEN(DATE(@sheet1,C:C;,"MM/dd/yyyy"),DATE_ADD(TODAY()-10),TODAY()-4)))

However this is some kind of an error (bad syntax would be my guess). Any help would be appreciated! Thanks.

1 comment

  • 0
    Avatar
    Keely Davison

    Hi Kevin,

    In the example you are showing you need the first parameter of your GROUP and GROUBY to be the same data.

    In the GROUP, you are currently pointing to column A instead of column H.  

    Hopefully changing that will resolve your issue but if not please email support@klipfolio.com and we can help you in more detail through a support ticket.

    Keely

Please sign in to leave a comment.