Forum Discussion

Tom1898's avatar
Tom1898
Frequent Visitor
5 years ago
Solved

Dataflow - How to add a value into a cell

Dear community

 

Currently, I am creating a dataflow where I receive following data from the source:

 

f.e.

300000

300100

303011

 

I would like to have all values in decimal format (even 300000 must be 3000.00), unfortunately, I am not able to create the following values:

 

3000.00

3001.00

3030.11

 

 

Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Tom1898 ,

     

    You can try to divide this column by 100, then change the data type to fixed decimal number.

     

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

2 Replies

  • Jakinta's avatar
    Jakinta
    Solution Sage
    5 years ago

    Hi,

     

    You can try the step below. Make sure before that your column data type is number.

     

     

    Table.TransformColumns(PreviousStep, {{ColumnName, each Number.ToText(_ / 100,"0.00"), type number}})

     

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Tom1898 ,

     

    You can try to divide this column by 100, then change the data type to fixed decimal number.

     

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.