Divide one column by another

[BillyL14]

Hi

I have 2 columns, both which have numerical values in them. I have a third column in which I want the product of dividing the first column by the second. I have tried this formula.

How do I correct?

Thanks

[Emil_Kos]

Hi @BillyL14 ,

Remove = sign and it will work. 

[ImadZidan · Accepted solution]

Hello @BillyL14 ,

Loose the equal.

Take the equal out

[Net Wt]/[Gr Wt]

[BillyL14]

Hi

Thanks, that worked

However, I would like the answer to come to several decimal places, how can I do that?

[Emil_Kos]

Hi @BillyL14 ,

Please take a look into this article:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Round-to-two-decimal-places/td-p/17859

[ImadZidan · Accepted solution]

Hello @BillyL14 ,

Make sure the formula output type is double. see screenshot below.

[BillyL14]

thanks