Summary Report

What would cause my summary report, when summarized, not show the total for revenue in dollars?

Best Answer


  • Genevieve P.
    Genevieve P. Employee Admin

    Hi @cpontiff

    I see that you're Grouping the Report by Sheet. Is it possible that one of the sheets selected doesn't have currency formatting applied to its "Revenue of Accounts Initiated" column?

    This would then have the SUM numbers for that specific sheet displayed as numerical, which means that the top summary would also appear as numerical without the $ sign:

    To check this, scroll down in your Report to see if one specific Summary row is also missing the $ sign. Then go to the underlying sheet and adjust the column formatting to ensure currency formatting is applied to the entire column. This should then update that Summary row and therefore the Summary up at the very top!

    Let me know if this was the issue or not.



  • cpontiff
    Answer ✓

    Thanks for the reply Genevieve P !

    Unfortunately that wasn't the case. Both my sheets were formatted for dollars.

    However, when I woke up this morning, the totals were showing correctly. So all is good now.

    Thanks again!

  • Genevieve P.
    Genevieve P. Employee Admin

    No problem, I'm glad it's working for you now!