Forum Discussion
Remove Decimals In Table
I want to show whole numbers. By default I have two decimal places in my table with numbers. How do I remove the decimal?
You can go to the data view, select the appropriate column, and then select the Modeling ribbon and then formatting tab. You can either change to a Whole Number or reduce Decimal Number to show 0 decimal places.
11 Replies
This worked for me! I wanted to report a measure both as a count and then as % of grand total, so I wasn't able to change the decimal places via Modeling since the original measure was a number, not a %.
Field formatting works for this reason.
Great solution! Thanks - good remark that from the drop down we need to select the proper measure (column) we want to remove the decimals for. The first column in my table was text column, so i did not see the option of adjusting decimals. But after i chose the proper column from the drop down menu- everything worked as a magic 🙂
It works. Thanks!
You can go to the data view, select the appropriate column, and then select the Modeling ribbon and then formatting tab. You can either change to a Whole Number or reduce Decimal Number to show 0 decimal places.
thanks this was driving me crazy!!
