How to enter decimal point where I want to

[Anonymous]

Hi

How can I add decimal point where I want to?

I have ex. number 521692155 in table but it should be 5216921,55.

If I use the comma tool in column tools it just adds 2 zeros on top if it like 521692155,00.

I also tried with Column = LEFT(table[data],7) + "," +RIGHT(table[data],2) but then it gives me error that "," cant be a number.

[Syndicate_Admin]

Ok incremental refresh would work fine but problem is now that I am using a custom SQL. That's why I can't get incremental refresh working for this report. I am going to redo the whole report but for now is there a way I could manually add missing last weeks data without overwriting? The report is almost 1GB big and already has around 6 months of data in it, I only need to add the last weeks data for viewers until I'm finished with the new improved report.

[amitchandak · Accepted solution]

@Anonymous , I think you should divide this number by 100

[Anonymous]

Of course, forgot about this, seems like I need a break 😄 thank you.