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?