Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Divide one column by another

BillyL14
8 - Asteroid

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.

WL1_0-1598118063343.png

 

How do I correct?

 

Thanks

 

6 REPLIES 6
Emil_Kos
17 - Castor
17 - Castor

Hi @BillyL14 ,

 

Remove = sign and it will work. 

ImadZidan
12 - Quasar

Hello @BillyL14 ,

 

Loose the equal.

 

Take the equal out

 

[Net Wt]/[Gr Wt]

BillyL14
8 - Asteroid

Hi

Thanks, that worked

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

WL1_0-1598118286656.png

 

Emil_Kos
17 - Castor
17 - Castor
ImadZidan
12 - Quasar

Hello @BillyL14 ,

 

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

 

Formula Result.PNG

BillyL14
8 - Asteroid

thanks

Labels