Removing Decimals from Duration Average Calculation

ocak

I have a report of every project timeline in my portfolio and an average duration calculation grouped by project phase. I would like to have the averages be displayed as whole numbers but there is no way to remove the decimal place on the report. The parent sheets don't have decimals so I'm not sure why they would appear when added in the report. Does anyone know how to get rid of the decimal? Any help is much appreciated, thank you in advance!

kowal

hi @ocak,

thanks to you I learnt sth new today.

Despite it's possible to remove decimals in Sheet I do not see the option to remove those in Report.

I think it shall be mentioned in New Product Ideas section of this community.

ocak

@kowal thank you for checking, I have posted this to the new idea thread!