How to do a product of all rows in a column in Tableau

Question

I have a column as below. I want to multiply all values together and get one value across

Yield

0.90

0.85

0.71

0.25

Yield Total_Prod

0.90   0.135

0.85   0.135

0.71   0.135

0.25   0.135

Where Total_Prod = 0.90*0.85*0.71*0.25 

Answer 1

• Running product is given by this calculation. Refer to this Link

[RP] : EXP(RUNNING_SUM(LN(SUM([Yield]))))

• But In order to find the Total Product use this calculation :

LOOKUP([RP],LAST())

To get the output like this:

• Running total using Exp and Log rules explains exp and how formula works and More info on Lookup by examples the lookup is used to navigate the different results in your view.It takes parameters to give the navigational control. More Info on last Last value in your view is the final result of the calculation.