Hi,
I would like to do further work on this attached workflow. For some reason when the return date and the next departure date is same it is not picking up correctly. i have use the formula provided on the previous discussion. Also I am having issues with using continuous days and aggregate to number of days . It is splitting up the details.
If there is someone willing to work with this workflow, happy to message separately to get through few teething issues on this workflow.
Attached the file I am expecting to see where when in a year employee go few different times but then it is continuous and need to provide the breakdown as highlighted - output file.
Thanks
Can't see the input as you gave a .yxmd file. Export your workflow like so: https://www.thedataschool.co.uk/stephanie-kearns/save-alteryx-workflow-packaged-file/
Without the assets, we don't know what you're talking about. Also, who built this workflow? Someone from the community or someone from your company?
We had Data school to assist us with the few different project at the same time. There isn't enough time to understand the technicality of the tax issues so only the basic were done , but then I did go through the community and get few things to fix it.
However it needs bit more clarity on the continuous days based on the report without changing the original report and need to summarise in a particular way. I have removed some of the information, but hopefully I can resolve some of the basics of the report.