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 

BartEdgerton's avatar
BartEdgerton
Icon for Advocate I rankAdvocate I
8 years ago

The entire Formatting section of the Modeling tab is grayed out.  Any other ideas?  None of this is working..

  • Drors's avatar
    Drors
    Icon for Resolver III rankResolver III
    8 years ago

    You should click on the spacific column before you go to the modeling tab, then you will be to remove the decimal point or to change to column type