Convert Wh to kWh by multiply and keeping 3 decimals

[Tmanuela]

Hi Community,

I am trying to convert a bunch of Electr Wh readings to kWh by multiply it in Multi Row Formula with 0.001 and unfortunately the result comes rounded up, which in this case does not help me.

What I want to have is to keep 3 decimals after conversion, tried with round and keeping the format of 0.001 or to multiply it with this number but the results are the same-rounded with no decimals.

Is this possible with some tool within Alteryx?

Below in last picture is what looks the conversion in Excel

.         

 

Best,

Manuela

[ehughes]

Hi Manuela,

I would suggest using the Formula tool like in the image below. The formula tool works at a row level so when you multiply by 0.001 it will apply this to each row individually. (Make sure you remember to change the Data type to 'Double')

The output looks like this 

[atcodedog05]

Hi @Tmanuela 

You need to use fixed decimal datatype. And sets decimal points. Scale : 3

[DavidP · Accepted solution]

Hi @Tmanuela 

The main problem is with your dataype - Int16 or Int32 or Byte are integer types, which mean whole numbers only. The Float, Double and Fixed Decimal types support decimals.

Also, you don't need a multi-row formula, you can just use a normal formula tool. Here's an example

[atcodedog05 · Accepted solution]

Hi @Tmanuela 

Here is a workflow: you need to do like this.

Hope this helps 🙂

[atcodedog05]

_

[atcodedog05]

Happy to help 🙂 @Tmanuela 

Cheers and Happy Analyzing 😀

Feel free to reach out if you face any issues 🙂

[Tmanuela]

Thank you @atcodedog05  , is always simple details that makes difference, is now working great🤩

[Tmanuela]

Hi @DavidP , Thanks for your solution, appreciate very much the explanations as well which makes things clear🤩