TIMESUM with LOOKUP

I have an issue where I am creating a fillable form for a client that includes entering a start and end date. So the user would chose a client and then a product, enter start and end dates and I need to then sum the revenue based on those choices. So, ideally I would be able to TIMESUM based on the dates chosen and LOOKUP the client and product. From what I understand I cant use TIMESUM with LOOKUP so what is the workaround? 

It's been suggested to use a staging module but the dates are user input so I am not sure how that would work?

Answers

  • Hi @JBeauchs 

    Would have module a that's dimensioned with time and does the lookup for client/product selection and then do the timesum off the back of this.

    You can do the other way around but is likely to create a larger module combination than is needed.

    Andrew