Can you change the number of decimal places in a report's "Total" field for averages?
Answers
-
Hi, Michael.
You can use the ROUND() function for this.
= ROUND( your_current_formula , 2)
You'll find documentation for this function, and others, here, https://help.smartsheet.com/functions
0 -
Thanks for answering my question. Unfortunately, this is in a report, not a sheet. It seems that reports do not allow you do do...well...anything at all. I can't find how to add or edit any information, including formulas.
To be clear, the numbers are in the sheet which are then pulled into the report and averaged inside the report. I suppose I could manually do this by averaging them (with a ROUND) inside the sheet myself and then pulling those lines in. I was just hoping that I could do this more cleanly by simply pulling the data into the report. I like how it had a nice drop-down for each manager and looked pretty clean.
0 -
I have the same question. I would like to change the decimal length on reports. Has it been determined if this is possible?
0 -
I've had success by reducing the decimals in the reference source sheet.
0 -
I'm also looking to do the same. Haven't had any success yet. I can get it to work the way I want by reducing decimals in the reference source sheet (as Paula suggested) but then it reverts back. Not sure what I need to do to get it to stick. Any ideas?
0 -
Just checking in to see if there have been any solutions to this issue. My source grid is formatted properly (I'm using currency $ w/0 decimals) but the report in my dashboard is showing 2 #'s after the decimal point.
0 -
Adding my name here as I would love to see rounding capability in Smartsheet reports.
0