Discrepancy in Grand Total column total? | Community
Skip to main content
gkrajeski
Level 10
June 2, 2016
Question

Discrepancy in Grand Total column total?

  • June 2, 2016
  • 2 replies
  • 3124 views

I was wondering if anyone else using RCE sees a discrepancy in the Grand Total of Unique clicks?

When I run a Subtotal formula in an excel export of my RCE Email Performance by Name report, I am getting different values.

Please see screenshot and formula.

As an FYI, I have no filters currently enabled on this spreadsheet!

Is this potentially Marketo telling me that people had unique clicks across emails?  That does not make sense to me as the Grand Total should be a sum of all clicks.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

2 replies

Kenny_Elkington
Adobe Employee
Adobe Employee
June 3, 2016

Can you give a screenshot of your report in RCE?

gkrajeski
gkrajeskiAuthor
Level 10
June 3, 2016

It's the same as the export, just with the filters exposed, but here you go.

Thanks!

Jim_Thao7
Level 8
June 3, 2016

Could it be possible that some values changed in your spreadsheet, maybe incidentally?

The "Grand Total" when exported is no longer a formula, just a static value.  I would check to see that the actual values for the ~70 rows match up to what's in RCE in the Unique Clicks column.