I have a Pivot View Report that I'm using for a weekly report, our Projects in Zoho projects are split into different groups, this report is summarising the total number of hours that have been booked against Project Groups.

I have identified that there is an error in the data.

The issues seems to be that there are a handful of timesheet logs from various projects/tasks that for whatever reason do not have a Project Group associated with them - Even though there are similar logs for that exact task that do have a Project Group.

Does anyone have any idea what could be causing the issue?