Aggregate SUM condition combining from multiple groups
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-06-2025 07:39 AM
Hi all,
I'm still getting to grips with SPM, but am getting there slowly. I have created an availability report, which is designed to show a users' availability in given month, by person days. For someone who is only attached to one group, it works as expected. E.g. 20 working days available in Feb 2025 to dedicate to project work. However, for someone who works across multiple groups, it's multiplying their availability. E.g. someone is attached to 3 groups and in Feb 2025 they have 60 available working days to be assigned to a project. Obviously, this is not feasible. Non project time is where I have allocated an operational plan to consume 20% of their time for admin/bau work etc, which is also being multiplied.
Ideally, I'd like to show a single view of someone's availability across all groups but not have them multiplied. I can separate reports by group, but that would then take a manual intervention to look at two or more reports and caluclate availability. Does anyone know a way around this or has encountered it before?
Thanks,