Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have loaded the following table with employees requested vacations.
The columns are : employee_code, from_date, to_date, days_requested
The data are:
1 06/11/2019 07/11/2019 2
2 4/11/2019 08/11/2019 5
I want to create a table to display the days_requested per employee by selecting from a filter pane date_from and date_to.
The problem is that when i select range 06/11/2019 - 07/11/2019 it will show only the first row but i want also the second line and instead of 5 days requested to show only the days between the selected range, again 2 days.
How can i do this ?
Thank you,
Noel
Hi,
try to see file attached
thank you very match 😊
Hello
I have noticed in your example that if i do not select any dates from filter pane the computed column "days" you added is wrong because it must be showing the same days with "days_requested".
How can i rectify this ?
Thanks
Noel
Hi,
you have to set the variable FROM as min instead of max, so it will work
Hi,
I change it but again the result is wrong
Thank you
Try to see file attached, here I see right numbers