Convert Wh to kWh by multiply and keeping 3 decimals

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

Workflow

Settings

Data Investigation

Accepted answers

DavidP

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

Hi @Tmanuela

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

Hope this helps 🙂

kwh.yxmd

All comments

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

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

Hi @Tmanuela

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

Hope this helps 🙂

kwh.yxmd

atcodedog05

Tmanuela

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

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15880

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703