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

0 votes

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.