Forum Discussion
Need calculation filtering data from another table with many to many relationship
Hello All, It is my first post so please accept appologise if some information may be inconsistent. I have started working on report that should provide real data with some technology utilisati...
Hi Anonymous ,
You can only filter the many side of the table relationship on the one side of the table relationship, so you need to use the "Date" in the Calendar table (Work Days Calendar) for filtering. I would like to know what is the formula for "holiday taken". Could you please share your sample data and expected result if you don't have any Confidential Information? Please upload your files to One Drive and share the link here.
Best Regards,
Community Support Team _ Joey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.