Grand total of row, not average of rates?

[Nicholas1127]

Hello all -

The "match rate" value in the "grand total" row is showing an average of the match rates above in the table.  How do I calculate the match rate as the accurate percentage of the known users/total visitors in the grand total row? (help!)

[Looker_Studio_B · Accepted solution]

Hey there, 

Your formula might be missing the SUM, it should be SUM(Known Users)/SUM(Total Visitors) instead of Know Users/Total Visitors.

Does it solve the issue?

[Nicholas1127]

Yep - that was the solve!  THank you so much.  I appreciate your feedback!