9 Replies Latest reply on Jul 9, 2018 5:08 AM by Bhupendra Rajawat

# Implement Sum Product in Tableau

I have a calculated field which has the formula SUMProduct(B1:B16,F1:F16)/SUM(B!:B16) [Its a excel formula and I have implemented this in Tableau]. I have tried to implement this but the output doesn't seem to be correct. Can somebody explain how can I implement this. Also, I want this output to be same throughout all the rows. Any help is appreciated.

• ###### 1. Re: Implement Sum Product in Tableau

Hi Bhuependra,

Try SUM([Your Data]+[Your data])/SUM([Your Data]).  But really, without some mocked up data or a workbook, it's difficult to tell if that's workable.  Thx, Don

• ###### 2. Re: Implement Sum Product in Tableau

Hi Bhuependra,

For SUMPRODUCT use:

SUM(<column B name> x <column F name>)

Hope that helps,

Vinnie

• ###### 3. Re: Implement Sum Product in Tableau

Hi Bhupendra

Your Tableau formula is as below

(Sum(B1:B16) + Sum(F1:F16)) / SUM(B!:B16)

* if you want to make it % just Multiply it by 100 (Ex.  ((Sum(B1:B16) + Sum(F1:F16))/SUM(B!:B16))*100)

Thanks

Alok

• ###### 4. Re: Implement Sum Product in Tableau

Like This?

Thanks

Deepak

• ###### 5. Re: Implement Sum Product in Tableau

Hey Deepak,

You are the closest to what I was doing and want to do but the issue is that the Sales is "Installs",  and  {Profit} part in my calculation is actually a Calculated Field and whenever I try to use this formula it gives me an error saying Cannot mix aggregate and non aggregate function using "*". Any idea how to counter this.

• ###### 6. Re: Implement Sum Product in Tableau

This is still doable, but I need to see your workbook, As without that I must be Guessing and I am not good at that.

Thanks

Deepak

• ###### 7. Re: Implement Sum Product in Tableau

Hey Deepak Rai, I am attaching sample workbook of my data. I am also attaching the excel files which shows the actual calculations. I have tried multiple methods to implements these equations in tableau but the answer seems to be wrong. Any help would be appreciated

• ###### 8. Re: Implement Sum Product in Tableau

There is no wb attached Sir

• ###### 9. Re: Implement Sum Product in Tableau

Hey Deepak Rai, I have attached it to the last comment.