I have a Bookings report that is doubling the value of any order that has more than one partner attached to it. Any ideas on how to have it not do that?

Look at the multiple ‘joins’ that you have. If it’s a Saved search you could use Maximum instead of Sun.

this is a report, not a saved search, so no way to view joins (that i'm aware of)

I was wondering if additional columns were added via the joins on the left?

not sure, these are the only top level items I have available

Click into Bookings then scroll down to the joins. I’m wondering if some of these are already added as Columns and causing the duplication.

okay, so you're saying the sub expandable options are the joins? I that case I am using at least one. I was unable to use the header level Booking field becaue it only displayed the internal ID, not the name, but I'm not even using any fields related to Relationship -> Partner.

That was my thought. If you remove the Partner column and preview does that remove the duplication? If so then we find another way to add Partner

unfortunately no, removing it still is multiplying teh value