Details about this thread
  • State Verified Answer
  • Replies 4 replies
  • Subscribers 312 subscribers
  • Views 1415 views
  • Users 0 members are here

Grand Total í Matrix report is not adding up

Kristjan Geir Mathiesen

Hi folks!

I have this report:
Type: Matrix Report
Modules: Opportunities, Opportunities > Assigned to User
Display Columns: <empty - none>
Group By: User Name, Probability (%)
Teams: Global (Primary)
Summary Columns: User Name, Probability (%), SUM: Amount
My problem: The Grand Total is not tallying up when there are more than 1 number per column:

What could I be doing wrong?

Takk,
KGM

  • 0

    Hi Kristjan,

    Is kr the default currency? If not, have you tried switching to the default currency field - or a non-currency field - to see if the behavior is the same? 

    Business Analyst

    Technology Advisors, Inc.

  • 0 in reply to Megan Sheehan

    Hi Megan Sheehan

    Yes, I believe kr is the default one. At least this is the setting in Admin:

    So any other ideas?

    Takk,

    KGM

  • 0 in reply to Kristjan Geir Mathiesen

    What version of Sugar is this? I tried in 7.9 and 7.7 (first two I could quickly get my hands on) and can't replicate. Not sure if the fact that I'm using USD has any impact or not. 

    What if you use SUM: Converted Amount instead of SUM: Amount? If you sum a non-currency field, do you still get the same issue? 

    Business Analyst

    Technology Advisors, Inc.

  • 0 in reply to Megan Sheehan

    Hi again Megan Sheehan

    Sorry, 7.9 but I also noticed some "summing up problem" when we were in 7.8.

    Using SUM: Converted Amount is also broken. However, it can sum up non currency field, here is Count:

    Therefore, this is likely tied to the currency, which would be no surprise.

    Update: We swapped the kr out for USD and the matrix works fine. I am opening up a support ticket.

    Thanks so much for your help and ideas Megan,

    KGM