Forum Discussion

Bando's avatar
Bando
Frequent Visitor
9 years ago
Solved

Edit query not changing format

I'm using edit query to transform data from and Excel table to get the correct formatts for my work. You can see from the query below that the formatting changes seem to be made but when I look at th...
Need Help
  • MarcelBeug's avatar
    MarcelBeug
    9 years ago

    OK, the data type Percentage doesn't exist in the data model, but you can use decimal number, with format percentage.

     

     

    Alternatively, if you want e.g. 25% to show up as 25 in the data model, you need to multiply the values by 100.

     

     

MarcelBeug's avatar
MarcelBeug
Icon for Community Champion rankCommunity Champion
9 years ago

Do you mean the percentages?

Bando's avatar
Bando
Frequent Visitor
9 years ago

Yeah the percentages. Thanks

  • MarcelBeug's avatar
    MarcelBeug
    Icon for Community Champion rankCommunity Champion
    9 years ago

    OK, the data type Percentage doesn't exist in the data model, but you can use decimal number, with format percentage.

     

     

    Alternatively, if you want e.g. 25% to show up as 25 in the data model, you need to multiply the values by 100.

     

     

    • lkrombach's avatar
      lkrombach
      New Member
      8 years ago

      Having a similar issue with the query formatting functionality --> not with percentages but with Time (duration). I'm seeing that I have the capability to transform the column "data type" to duration but it still will not "apply" to the data model.