Rounding Summary Numbers in Reports

AshleyDeichmueller

We have reports that show us turnaround times for certain items. We are using the summarize feature to take an average for those turnaround times, but the decimals do not come out cleanly or consistently. Is there a way to round these averages so that it is a whole number?

Samuel Mueller

@AshleyDeichmueller glad you got it partially working! also just FYI you would need every source sheet to be formatted the same, just confirming you have done that as well.

Samuel Mueller

@AshleyDeichmueller If you go to the source sheet(s) and format that column as a number with the decimals you want it to show, then it should update on the report to match that. Do it to the whole column. let me know if that works

AshleyDeichmueller

@Samuel Mueller I have tried increasing the decimal, saving, then decreasing back down to no decimal points and it still does not round the average in the report. Is there anything else I can try?

Samuel Mueller

@AshleyDeichmueller I'm sorry I don't know any other options, and it works in my example. try formatting the column to have one decimal and then save your sheet. And then go to your report refresh it and see if that works.

Do you have multiple source sheets?

AshleyDeichmueller

@Samuel Mueller Yes there are multiple source sheets. I tried doing it with two decimals and it worked for consistency! I don't think the whole numbers worked, but the 2 decimals should be fine. Thanks for your help!!

Samuel Mueller

@AshleyDeichmueller glad you got it partially working! also just FYI you would need every source sheet to be formatted the same, just confirming you have done that as well.