Make last two digits of an integer number into decimals

[felipeschiavon]

Hi, first question here. I think it's simples, but I couldn't find an answer.

I have numbers as integers in a column and I want to convert to decimal number, with the last two digits as decimals. But PBI is adding 00 at the end.

Example:
How it is: 1789
How PBI converts: 1789.00
How I want: 17.89

Thanks in advance!

[amitchandak · Accepted solution]

Create a new column divide by 100

new Column = [Number]/100

[felipeschiavon]

Thanks @amitchandak! I tought it had a "config" way, but your solution solved the problem!