Forum Discussion

kalcey's avatar
kalcey
Frequent Visitor
9 years ago

Decimal places on average, be gone!

Is there a way to get rid of the decimal point in an Whole Number column, where the average is calculated using the Visualisations pane?   I could add a measure sales (avg) = AVERAGE([Sales]) and f...
Need Help
rogerta's avatar
rogerta
Icon for Advocate I rankAdvocate I
8 years ago

Solved it in the end by re-formatting the data type to "Fixed decimal number" in the Modelling tab 

kateshepardphd's avatar
kateshepardphd
Icon for Advocate I rankAdvocate I
3 years ago

Wow, I can't believe it worked, changing it to "Fixed decimal number". Thanks so much!! (I still don't quite understand "whole number" vs. "decimal number" vs. "fixed decimal number", especially after this scenario in which "fixed decimal number" changes the average to a whole number! 🤦🏽‍♀️ ).