10 Replies Latest reply on Jun 20, 2018 5:09 PM by Helen Wang

# How to create a new column/calculation and let the left number divide the right number? (Sample Workbook Attached)

Hi Everyone:

I have been trying to get my ERR\$in ABS(M3) divide the Q4 Ship Act(\$) as WMAPE.

But there is no way for me to create this calcualtion/column.

I have attached the sample workbook.

Thanks,

Helen • ###### 1. Re: How to create a new column/calculation and let the left number divide the right number? (Sample Workbook Attached)

Please attach  a.twbx. We can't open .twb

• ###### 2. Re: How to create a new column/calculation and let the left number divide the right number? (Sample Workbook Attached)

Thank you so much Deepak! Look forward to your help!

• ###### 3. Re: How to create a new column/calculation and let the left number divide the right number? (Sample Workbook Attached)

Pl See attached.

Thanks

Deepak

If it Helps, Pl mark it Helpful and  CORRECT to close Thread • ###### 4. Re: How to create a new column/calculation and let the left number divide the right number? (Sample Workbook Attached)

Hi Deepak,

Thank you very much. But I actually want the value of:

566,439/2,455,625 = 0.2306

Tableau told me it is valid, but it is not showing 0.2306 as the result.  I need ERR\$ in ABS(M3)/ Q4 Ship Act(\$)

: For example:

566,439/2455,625=0.230

18,749/71,992=0.2603

58,565/229,544=0.25512

It is just a simple calculation in Excel but I don't know how to realize this in Tableau.

Thank you so much for your help,

Helen

• ###### 6. Re: How to create a new column/calculation and let the left number divide the right number? (Sample Workbook Attached)

attachment.

If it Helps, pl close Thread by marking my reply as Helpful and CORRECT

Thanks

Deepak

1 of 1 people found this helpful
• ###### 7. Re: How to create a new column/calculation and let the left number divide the right number? (Sample Workbook Attached)

It really helps!

May I ask how do you change the calculation from SUM() to AGG()??

• ###### 8. Re: How to create a new column/calculation and let the left number divide the right number? (Sample Workbook Attached)

In Tableau, when you divide 2 SUM calculations, You get AGG because you are dividing one aggregarte with other.

• ###### 9. Re: How to create a new column/calculation and let the left number divide the right number? (Sample Workbook Attached)

Thank you very much for your help! I have marked you as correct and helpful.

Hope you have a very nice day.

Helen

• ###### 10. Re: How to create a new column/calculation and let the left number divide the right number? (Sample Workbook Attached)

Hi Deepak!

Hope you are doing well!

If you have time, could you please help me take a look at this question?

Thanks!