Hi guys,
On my [Revenue] table, I’m trying to compute the expected revenue that I’ll get from a client. The client processes payments twice a month after the work sessions are completed. We have struck a deal that spans multiple payment periods.
To this end, on my [Revenue] table, I’m trying to set a dynamic filter on a lookup of the Sessions field, which is itself a lookup on the [Deals] table. I want the Sessions field on the [Revenue] table to display only the sessions – hourly sessions or weekly sprints – that ended after the Work Period Start Date and before the Work Period End Date. This would then allow me to sum the compensation due for each session within this work period with a rollup.
The thing is, it seems I can’t set up a dynamic filter on a lookup.
Do you guys confirm?
If so, which workaround would you suggest?
Thanks for your help.